1

I'm trying to import a dump file with the command below:

impdp system/password dumpfile=mw0sd1.dmp keep_master=Y

But it returns following error:

ORA-39002: invalid operation
ORA-39059: dump file set is incomplete
ORA-39246: cannot locate master table within provided dump files

I've been checked logfile and didn't found any error for master table.

Export: Release 11.2.0.3.0 - Production on Fri Mar 2 01:31:27 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
;;; 
Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Starting "SYS"."SYS_EXPORT_SCHEMA_02":  userid="/******** AS SYSDBA" directory=BKPSQL1 dumpfile=BKP_MW0SD1_PONTUAL_2392329.dmp LOGFILE=BKP_MW0SD1_PONTUAL_2392329.log SCHEMAS=MW0SD1

Master Table:

Master table "SYS"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
    ******************************************************************************
    Dump file set for SYS.SYS_EXPORT_SCHEMA_02 is:
      /home/oracle/orabkp/BKPORA/ORAINST1/SQL1/BKP_MW0SD1_PONTUAL_2392329.dmp
    Job "SYS"."SYS_EXPORT_SCHEMA_02" successfully completed at 03:46:24

I'll appreciate so much If anyone could help me to solve this question ASAP. Already exported this database 2 times for make sure that is not an export problem.

Thanks.

2
  • What was the expdp command that was used? Mar 15, 2018 at 15:25
  • 1
    Run impdp with trace=1ff0300 and post the trace file that was created. So far all I can tell is your dumpfile is corrupted. Mar 15, 2018 at 15:48

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.