ORA-31626: job does not exist ORA-06512: at "SYS.DBMS_DATAPUMP" error

ORA-31626: job does not exist
 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
 ORA-06512: at "SYS.DBMS_DATAPUMP", line 1470
 ORA-06512: at "SYS.DBMS_DATAPUMP", line 5887
 ORA-06512: at line 1

Solution:

----------

there are different situation we will get this error.

1) If your database user dont have access like execute privileges for DBMS_DATAPUMP 

   package we will get this error

Sol: grant execute privileges to user.

      SQL> conn SYS as SYSDBA

      SQL> grant execute on DBMS_DATAPUMP to username;

2) IF previous jobs are not finished or idle state then we will get this error.

    using below query we can verify existing jobs.

SQL> SELECT owner_name, job_name, operation, job_mode, state, attached_sessions FROM dba_datapump_jobs;
  
OWNER_NAME JOB_NAME             OPERATION  JOB_MODE   STATE        ATTACHED_SESSIONS
---------- -------------------- ---------- ---------- ------------ -----------------
SYS        BIAPPSDBJOB          IMPORT     FULL       NOT RUNNING   0

drop table using

SQL>  DROP TABLE BIAPPDBJOB;

verify it is available in recyclebin using above query again, then  purge using like below.

SQL> PURGE TABLE BIAPPDBJOB;