This discussion is archived
9 Replies Latest reply: Oct 29, 2012 2:55 PM by 586047 RSS

Data Pump Import and Export Hangs Indefinitely

909434 Newbie
Currently Being Moderated
Hi

So the other day for no reason i can think of the import and export utility has stopped working, i've imported and exported hundreds of times before on this oracle install so theres no problem in that respect, tried restarting the services, turning the machine off and on lol etc. No obvious reason why its happening that i can think of, couldn't really find anything related to my problem on google with the error message i get. Anyone got any ideas?


--------------------

C:\>impdp OFF/tallyman directory=ROOT schemas=OFF dumpfile=OFF_362_291111.dmp logfile=lohj.log

Import: Release 11.2.0.1.0 - Production on Fri Jan 6 15:56:19 2012

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

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


------------------------------------------

so i run the command and it stops at the disclaimer bit above indefinitely (left it on over night it was still the same when i got back)

when i cancel the operation i get the following error messages


--------------------------------------------

UDI-00001: user requested cancel of current operation

ORA-24550: signal received: Unhandled exception: Code=c0000029 Flags=1


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

UDI-22166: operation generated ORACLE error 22166
OCI-22166: collection is empty

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

UDI-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle

Legend

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