Database Administration (MOSC)

MOSC Banner

ORA-39083Object type JOB failed to create with error: ORA-00001 ... during impdp with n

edited May 13, 2015 5:26AM in Database Administration (MOSC) 1 commentAnswered ✓

Hello,

During impdp, I'am getting following error:

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=> 362, LUSER=> 'USR', PUSER=> 'USR', CUSER=> 'USR', NEXT_DATE=> TO_DATE('4000-01-01 00:00:00', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'TRUNC(SYSDATE)+ 1 + 6/24', BROKEN=>  TRUE, WHAT=> 'PACKAGE.JobSchedulerRun;', NLSENV=> 'NLS_LANGUAGE=''AMERICAN'' NLS_TERRITORY=''AMERICA'' NLS_CURRENCY=''$'' NLS_ISO_CURRENCY=''AMERICA'' NLS_NUMERIC_CHARACTERS=''.,'' NL

ORA-39083: Object type JOB failed to create with error:

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center