impdp ORA-00001: unique constraint (SYS.I_JOB_JOB) violated

I encountered the following error when I import a dmp file to oracle database.

Processing object type SCHEMA_EXPORT/JOB
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Failing sql is:
BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 184, LUSER=> ‘DEST_USER’, PUSER=> ‘DEST_USER’, CUSER=> ‘DEST_USER’, NEXT_DATE=> TO_DATE(‘2019-10-06 02:00:00’, ‘YYYY-MM-DD:HH24:MI:SS’), INTERVAL=> ‘TRUNC(next_day(sysdate,”SUNDAY”))+2/24’, BROKEN=> FALSE, WHAT=> ‘DBMS_STATS.gather_schema_stats(””);’, NLSENV=> ‘NLS_LANGUAGE=”AMERICAN” NLS_TERRITORY=”AMERICA” NLS_CURRENCY=”$” NLS_I

Job “instance_PREP1”.”SYS_IMPORT_FULL_01″ completed with 7934 error(s) at Sat Dec 14 06:39:43 2019 elapsed 0 00:01:23

I confirmed the job 184 in oracle command line and discoverd that this job indeed exist.
SQL> select job, what from dba_jobs where job=184;

Solution

Drop this job in dbms. I connected dababase by PL/SQL and performed this operation. Afterwords the error no longer appeared when I import dmp file.

Leave a Reply