This discussion is archived
9 Replies Latest reply: Feb 27, 2013 10:04 AM by imarek78 RSS

Oracle 11.2 Datapump throwing UDI-31623 error

yharish05 Newbie
Currently Being Moderated
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


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