Database Utilities (MOSC)

MOSC Banner

IMPDP error

edited Feb 15, 2017 4:00AM in Database Utilities (MOSC) 9 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center