9 Replies Latest reply: Oct 29, 2012 4:55 PM by user583044 RSS

    Data Pump Import and Export Hangs Indefinitely

    909434
      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