Skip to Main Content

SQL Developer

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!

ORA-31635, ORA-31637 during impdp

3743596Sep 14 2018

Hello Gurus,

Encountering below errors during import:

ORA-31626: job does not exist

ORA-31637: cannot create job SYS_IMPORT_SCHEMA .... FOR USER .....

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT_INT", line 810

ORA-31635: unable to establish job resource synchronization

Followed instructions in Doc ID 453338.1, Step 2 as I don't have access to DB Server and can't execute step 1.

Query  select owner_name,job_name,state from dba_datapump_jobs doesn't return any row.

Is it possible that there is no row in dba_datapump_jobs but still orphaned OS level process for impdp?

Thanks.

Vin

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2018
Added on Sep 14 2018
0 comments
667 views