6 Replies Latest reply: Jan 10, 2013 12:39 PM by Dean Gagne RSS

    Error importing export to

    Andreas S.
      Hi all,

      we have two machines. let's call them db_1 and db_2.
      db_1 has version, db_2 is a clone of db_! and has been updated by our dba to

      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_11.2.0.1_20130110_1217.expdp LOGFILE=XY_11.2.0.1_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_11.2.0.1_20130110_1217.expdp.log REMAP_TABLESPACE='XY_PERM':'XYZ_PERM', REMAP_SCHEMA='XY':'XYZ' SCHEMAS='XY' DIRECTORY=DATA_PUMP_DIR DUMPFILE=XY_11.2.0.1_20130110_1217.expdp

      I got the following errors (sorry, I only have German error messages):

      Import: Release - Production on Thu Jan 10 12:46:22 2013

      Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

      Username: XYZ

      Connected to: Oracle Database 11g Enterprise Edition Release - 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,