Error
ORA-31634 : job already exists while taking backup through DATAPUMP(expdp)
Cause
If the entries in DBA_DATAPUMP_JOBS table become equals to 99 for any particular schema then “ORA-31634 : job already exists”
SELECT owner_name,job_name,operation,state FROM DBA_DATAPUMP_JOBS;
Solution
select owner,table_name from dba_tables where table_name like '%SYS%EXPORT%';
- Drop the SYSTEM.SYS_EXPORT_FULL_01 until 99 tables and re-try running the expdp backup
