ORA-31634: job already exists

Error: ORA-31634: job already exists ORA-31664: unable to construct unique job name when defaulted

Details: Error occurs when running a full data pump export

Cause:The table dba_datapump_jobs contains 99 orphaned jobs: The SQL below returns 99 rows:

select owner_name, job_name, state from dba_datapump_jobs order by job_name;

Solution:Remove the jobs that are not ruuning and purge them from recycle bin:

DROP TABLE OWNER_NAME.JOB_NAME;


PURGE DBA_RECYCLEBIN;


or


DROP TABLE OWNER_NAME.JOB_NAME PURGE;