Tuesday, January 21, 2014

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;

No comments:

Post a Comment