My Oracle Support Banner

Data Pump Import reports ORA-00001: unique constraint (SYS.I_JOB_JOB) violated, on BEGIN SYS.DBMS_IJOB.SUBMIT... (Doc ID 1531190.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.4 [Release 10.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Goal

On Data Pump Import with REMAP_SCHEMA (i.e. REMAP_SCHEMA old_value => 'USER1', value => 'USER2'),
the following errors occur;
  ORA-39083: Object type JOB failed to create with error:
  ORA-00001: unique constraint (SYS.I_JOB_JOB) violated

On examination, we see that the failing statement is a JOB submission:
Failing statement:
BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 139, LUSER=> 'USER2', PUSER=> 'USER2', CUSER=> 'USER2', NEXT_DATE=> TO_DATE('<DATE>','YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'SYSDATE + 1/24',  > BROKEN=> FALSE,
WHAT=> 'dbms_refresh.refresh(''"USER1"."<VIEW_NAME>"'');',
NLSENV=> 'NLS_LANGUAGE=''AMERICAN'' >NLS_TERRITORY=''AMERICA''
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.