Data Pump Import and Export Hangs Indefinitely
909434Jan 6 2012 — edited Oct 29 2012Hi
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