4 Replies Latest reply: Jul 11, 2013 1:41 AM by Sreejith_Nair RSS

    impdp failed with ORA-39002, ORA-31694 and ORA-31644

    633850
      Hi,

      I am experiencing some errors while trying to run impdp as shown below:

      -------------------------------------------------------------
      [oracle@10GLIN64 20080713]$ impdp system/******* dumpfile=prod13july1_afeod1.dmp remap_schema=prod:azizi130708 directory=AZIZI_DMP_DIR

      Import: Release 10.2.0.3.0 - 64bit Production on Tuesday, 29 July, 2008 17:37:23

      Copyright (c) 2003, 2005, Oracle. All rights reserved.

      Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
      With the Partitioning, OLAP and Data Mining options
      ORA-39002: invalid operation
      ORA-31694: master table "SYSTEM"."SYS_IMPORT_FULL_04" failed to load/unload
      ORA-31644: unable to position to block number 1996259 in dump file "/home/oracle/dmp/AZIZI/20080713/prod13july1_afeod1.dmp"
      -------------------------------------------------------------

      Before that, I already grant data pump directory to schema azizi130708 as below:

      GRANT READ,WRITE ON DIRECTORY AZIZI_DMP_DIR TO AZIZI130708;

      If anybody manage/have any idea how to overcome this error, hopefully can share with me the solution. Any kind of help are highly appreciated.

      Thank you.