ORA-39060: table(s) dropped because of conflict with master table
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



ORA-39060: table(s) dropped because of... Expand / Collapse
Message
Posted 6/20/2011 9:25:16 PM Post #570
 

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie
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

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 7:07pm

Powered By InstantForum.NET v4.1.4 © 2012
Execution: 0.023. 10 queries. Compression Disabled.
Contextual Links