we have two machines. let's call them db_1 and db_2.
db_1 has version 22.214.171.124, db_2 is a clone of db_! and has been updated by our dba to 126.96.36.199.
Now I need move a schema with its data from db_1 to db_2.
I used datapump for creating the export using the following command:
expdp DIRECTORY=DATA_PUMP_DIR DUMPFILE=XY_188.8.131.52_20130110_1217.expdp LOGFILE=XY_184.108.40.206_20130110_1217.expdp.log SCHEMAS=XY
I can see no errors in the logfile.
The exp-Log says: Master-Tabelle "XY"."SYS_EXPORT_SCHEMA_01" erfolgreich geladen/entladen -> so, everything is fine.
Now I tried to import the dump to db_2 by using this command:
impdp LOGFILE=XY_220.127.116.11_20130110_1217.expdp.log REMAP_TABLESPACE='XY_PERM':'XYZ_PERM', REMAP_SCHEMA='XY':'XYZ' SCHEMAS='XY' DIRECTORY=DATA_PUMP_DIR DUMPFILE=XY_18.104.22.168_20130110_1217.expdp
I got the following errors (sorry, I only have German error messages):
Import: Release 22.214.171.124.0 - Production on Thu Jan 10 12:46:22 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: Interner Fehler
ORA-39068: Ungultige Master-Tabellendaten in Zeile mit PROCESS_ORDER=-4 -> now I got an error with the master table, which was fine in the export
ORA-01536: Speicherplatz-Zuteilung fur Tablespace 'XYZ_PERM' uberschritten
ORA-39097: Bei Data Pump-Job ist ein unerwarteter Fehler -1536 aufgetreten
Can anyone help?
Thanks in advance,
This is saying that the master table could not be loaded. The master table created during the 188.8.131.52 export probably has more rows in it than 184.108.40.206 knows how do deal with. You need to add this to your export command:
This will generate a dumpfile with a master table that can be imported into 220.127.116.11.
Please let me know if that worked or not.
I should have added that you are essentially downgrading so you need to tell Data Pump on 18.104.22.168 that you want to be able to import into 22.214.171.124. To do this, use the version parameter during the export command.
You could also do this over the network link (if you have one defined on the target pointing to the source). In this case, no version is necessary since the Data Pump code on the source will negotiate the version with the Data Pump code on the target.
Hope this helps.