This discussion is archived
7 Replies Latest reply: May 9, 2012 5:48 AM by Fran RSS

Impdp error while attaching the job - Urgent - Prod batches are stopped

871106 Newbie
Currently Being Moderated
I am getting following error, when I invoke the following command.

impdp "'/ as sysdba'" attach ="SYS"."SYS_IMPORT_TABLE_01"

Connected to: Oracle Database 10g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-44003: invalid SQL name

ORA-39097: Data Pump job encountered unexpected error -44003

The actual import job was stopped with stop_job in impdp> prompt.

DB Version:

Please throw some lights to fix this issue. Production batches are already on hold. It is very urgent.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points