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 04, 2024
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 |