4 Replies Latest reply: Sep 30, 2013 4:29 AM by Jackie.KH RSS

    ORA-39060: table(s) dropped because of conflict with master table

    Jackie.KH

      Dear All,

       

      Currently I've encountered problem during I try to import whole schema

       

      bash-3.2$

      bash-3.2$ impdp  BALL/BALL_BALL@BALL dumpfile=PRODDUMP.DMP DIRECTORY=DUMP_DIR FULL=Y   LOGFILE=imp.Log   REMAP_SCHEMA=BALL:BALL REMAP_TABLESPACE=BALLDATA:BALLDATA

       

      Import: Release 11.2.0.3.0 - Production on Mon Sep 30 15:28:08 2013

       

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

       

      Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,

      Data Mining and Real Application Testing options

      ORA-39060: table(s) dropped because of conflict with master table

       

       

       

       

      UDI-31626: operation generated ORACLE error 31626

      ORA-31626: job does not exist

      ORA-39086: cannot retrieve job information

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551

      ORA-06512: at line 1

       

      Any solution please