7 Replies Latest reply: May 9, 2012 7:48 AM by Fran RSS

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

    871106
      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 10.2.0.2.0 - 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: 10.2.0.2.

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