9 Replies Latest reply on Feb 27, 2013 6:04 PM by imarek78

    Oracle 11.2 Datapump throwing UDI-31623 error

      I have iniciated a datapump import and realized that I gave a wrong tablespace name while remapping, then terminated the session and came out of impdp. but later when I tried to do import again I am getting below error. now even expdp and impdp both are throwing the below error. Please help me out here.

      impdp REMAP_TABLESPACE=CASE1705:IGNITE50 REMAP_SCHEMA=CASE1705:IGNITE55 directory=data_pump_dir DUMPFILE=MIG_DP_IGNITE_20110126.DMP log=imp_ignite55_20110131.log

      Import: Release - Production on Mon Jan 31 12:54:56 2011

      Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

      Username: system

      Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
      With the Partitioning, Automatic Storage Management, OLAP, Data Mining
      and Real Application Testing options

      UDI-31623: operation generated ORACLE error 31623
      ORA-31623: a job is not attached to this session via the specified handle
      ORA-06512: at "SYS.DBMS_DATAPUMP", line 3263
      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4488
      ORA-06512: at line 1

      Here is the alert log entry

      Mon Jan 31 12:55:10 2011
      Errors in file /ORACLE/app/oracle/diag/rdbms/esbdev/ESBDEV/trace/ESBDEV_ora_725058.trc (incident=134948):
      ORA-00600: internal error code, arguments: [kqlInvObj:user], [162], [], [], [], [], [], [], [], [], [], []
      Incident details in: /ORACLE/app/oracle/diag/rdbms/esbdev/ESBDEV/incident/incdir_134948/ESBDEV_ora_725058_i134948.trc
      Mon Jan 31 12:55:40 2011
      Trace dumping is performing id=[cdmp_20110131125540]
      Mon Jan 31 12:55:45 2011
      Sweep [inc][134948]: completed
      Sweep [inc2][134948]: completed