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
Share →
0 comments
Skip to toolbar