Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

633850Jul 30 2008 — edited Jul 11 2013

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.