Forum Stats

  • 3,782,948 Users
  • 2,254,713 Discussions
  • 7,880,227 Comments

Discussions

ORA-31626: job does not exist error. How to find the correct job name.

User_JCASA
User_JCASA Member Posts: 1 Blue Ribbon

I'm working developing Python Apps in ADB.

https://explore.oracle.com/developer/python-apps-workshop/?topic=Database&source=:em:ne:ie:pt::RC_WWMK201028P00043:Email3&elq_mid=177347&sh=2526092607191816290810031214&cmid=WWMK201028P00043

I'm trying to import tables by running a job. But it ends up in below error :-

ORA-31626: job does not exist ORA-06512: at line 37 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.DBMS_DATAPUMP", line 1849 ORA-06512: at "SYS.DBMS_DATAPUMP", line 6869 ORA-06512: at line 8

Import Job:-

dbms_datapump.open (operation => 'IMPORT', job_mode => 'SCHEMA', job_name => 'IMP_ALPHA', version => 'COMPATIBLE'); 


How do i find the right job name ?