Skip to Main Content

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!

unable to import dump files

3126158Feb 6 2017 — edited Feb 7 2017

Hi Folks,

I'm trying to restore using impdp my two different backup dump files and on both I'm getting different error messages that i cant understand well

one is

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-39002: invalid operation

ORA-31694: master table "SYSTEM"."SYS_IMPORT_TABLE_01" failed to load/unload

ORA-31644: unable to position to block number 33248124 in dump file "/ubpr/nov/T24PROD-20161202-post_01.dmp"

the second error is

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-39002: invalid operation

ORA-39059: dump file set is incomplete

ORA-39246: cannot locate master table within provided dump files

can someone help me interprete these two errors

  

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2017
Added on Feb 6 2017
9 comments
3,174 views