Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DataPump Import IMPDP Fails With Errors ORA-31626 ORA-6512 ORA-31637 ORA-31632 ORA-31635

Sankar KrishnamurthyJun 25 2015 — edited Jun 25 2015

While trying an impdp , I am getting following sequence of errors -

ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT", line 885
ORA-31637: cannot create job SYS_IMPORT_TABLE_01 for user SJM
ORA-31632: master table "SJM.SYS_IMPORT_TABLE_01" not found, invalid, or inaccessible
ORA-31635: unable to establish job resource synchronization
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 1986
ORA-04063: package body "SYS.DBMS_LOCK" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOCK"

Parameters passed for impdp are as under

impdp sjm/xxxxxx@flman700 DIRECTORY=temp_dir DUMPFILE=dyman01_exp01.dmp,dyman01_exp02.dmp,dyman01_exp03.dmp,dyman01_exp04.dmp,dyman01_exp05.dmp,dyman01_exp06.dmp LOGFILE=one.LOG TABLES=CST_ACTVT TABLE_EXISTS_ACTION=APPEND

Any help on how to proceed to further. Couldn't find any hung datapump jobs in the target database.

Source and target Database version - 10.2.0.3

Thanks

Sankar

This post has been answered by Richard Harrison . on Jun 25 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 23 2015

Added on Jun 25 2015

#database-key-features, #export-import-sql-loader-external-tables

16 comments

6,142 views