0 Replies Latest reply on Sep 14, 2018 5:06 AM by 3743596

    ORA-31635, ORA-31637 during impdp

    3743596

      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