Posted 6/20/2011 9:25:16 PM
|
|
|
|
| Hi, I am trying to import back the dump file into the schema and facing the below issue. We have cleared the schema before trying to import, the schema is completely empty i.e. select count(*) from user_ojects returns 0. Database version is 10.2.0.3. The database is a RAC database. We have checked with the DBA as we do not have admin access that the dumpfile do exist on the server under DATAPUMP_DIR directory itself. Any idea on the below error? Command: impdp <schema>\/<password>@<dbname> dumpfile=ESMSTG_BCKUP_JUNE132011.dmp directory=DATAPUMP_DIR logfile=ESMSTG_BCKUP_JUNE132011_imp.log parallel=4 Import: Release 10.2.0.3.0 - Production on Monday, 20 June, 2011 17:06:55 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options ORA-39060: table(s) dropped because of conflict with master table Master table "SWC"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "SWC"."SYS_IMPORT_FULL_01": SWC/********@ESMSTG1 dumpfile=ESMSTG_BCKUP_JUNE132011.dmp directory=DATAPUMP_DIR logfile=ESMSTG_BCKUP_JUNE132011_imp.log parallel=4 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105 ORA-06512: at "SYS.KUPW$WORKER", line 6351 ----- PL/SQL Call Stack ----- object line object handle number name 0x84ce2478 15032 package body SYS.KUPW$WORKER 0x84ce2478 6372 package body SYS.KUPW$WORKER 0x84ce2478 3579 package body SYS.KUPW$WORKER 0x84ce2478 6972 package body SYS.KUPW$WORKER 0x84ce2478 1314 package body SYS.KUPW$WORKER 0xb06730d8 2 anonymous block Job "SWC"."SYS_IMPORT_FULL_01" stopped due to fatal error at 20:07:03 Thanks in advance.
-Ani
|
|
|
|