This discussion is archived
11 Replies Latest reply: Mar 1, 2013 12:47 PM by Dean Gagne RSS

Error during import. datapump

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

Thanks

Legend

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