11 Replies Latest reply on Mar 1, 2013 8:47 PM by Dean Gagne-Oracle

    Error during import. datapump

      Hi All,

      I am getting error during import the Database.

      please see below errors what i am getting during impdp. I am using oracle 11g. on linux.

      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 2862
      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052
      ORA-06512: at line 1

      And below Is my import Db script.

      export ORACLE_SID='DBNAME'
      impdp system schemas=INVENTORY,RPT,PROMO directory=DP_DIR dumpfile=DW_metadata.dmp logfile=impDW_metadata.log


      I checked permission on DP_DIR directory and location of DP_DIR.

      Let me advise on this, if you faced this problem before.