17,377
社区成员
发帖
与我相关
我的任务
分享
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Failing sql is:
BEGIN DBMS_JOB.ISUBMIT( JOB=> 4, NEXT_DATE=> TO_DATE('2014-06-20 02:00:00', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'trunc(sysdate, ''dd'') + 1 + +2 / 24', WHAT=> 'p_pca_day_resource_install;', NO_PARSE=> TRUE); END;
Job "MMPORTRPT"."SYS_IMPORT_FULL_01" completed with 315 error(s) at 01:50:00