ORA-31634: job already exists

ORA-31634: job already exists

ORA-31664: unable to construct unique job name when defaulted

 

CHANGES

This can occur when either running a single DataPump jobs or when you are executing multiple jobs at the same time.

 

CAUSE

This can happen when you do not specify a unique JOB_NAME for the DataPump job (using a default name) and for some reason that JOB_NAME already exists, or if you are running many jobs at the same time (more than 99 jobs) and DataPump cannot build a unique name.

 

SOLUTION

1. If you are just running a single job then there are probably old job names that are still found in the database and this is creating the conflict. You could try to remove these job using the steps in the following

Note 336014.1 - How To Cleanup Orphaned DataPump Jobs In DBA_DATAPUMP_JOBS ?

 

Step 4. Determine in SQL*Plus the related master tables:

 

set linesize 200

col object_id format  9999999999

col status format a10

col object_type format a20

col owner.object format a50

SELECT o.status, o.object_id, o.object_type,

       o.owner||'.'||object_name "OWNER.OBJECT"

  FROM dba_objects o, dba_datapump_jobs j

WHERE o.owner=j.owner_name AND o.object_name=j.job_name

   AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;

 

STATUS         OBJECT_ID OBJECT_TYPE        OWNER.OBJECT

---------- ----------- -------------------- --------------------------------------------------

VALID         93402 TABLE            SYSTEM.SYS_EXPORT_SCHEMA_01

VALID         95879 TABLE            SYSTEM.SYS_EXPORT_SCHEMA_02

VALID         96699 TABLE            SYSTEM.SYS_EXPORT_SCHEMA_03

VALID         97237 TABLE            SYSTEM.SYS_EXPORT_SCHEMA_04

VALID         97586 TABLE            SYSTEM.SYS_EXPORT_SCHEMA_05

VALID        164752 TABLE            SYSTEM.SYS_EXPORT_SCHEMA_06

VALID        168101 TABLE            SYSTEM.SYS_EXPORT_SCHEMA_07

VALID        169481 TABLE            SYSTEM.SYS_EXPORT_SCHEMA_08

VALID        169559 TABLE            SYSTEM.SYS_EXPORT_SCHEMA_09

VALID        169854 TABLE            SYSTEM.SYS_EXPORT_SCHEMA_10

VALID        170398 TABLE            SYSTEM.SYS_EXPORT_SCHEMA_11

 

Step 5. For jobs that were stopped in the past and won't be restarted anymore, delete the master table. E.g.:

drop table SYSTEM.SYS_EXPORT_SCHEMA_01;

 

-- For systems with recycle bin additionally run:

purge dba_recyclebin;

 

参考链接

https://blog.youkuaiyun.com/lixiaohuiok111/article/details/19972525