| Errors While Import. [message #474487] |
Mon, 06 September 2010 13:40  |
madhavamanohar
Messages: 58
Registered: February 2009
|
Member |
|
|
Hi Team,
While doing import got the below errors.
Failing sql is:
BEGIN DBMS_JOB.ISUBMIT( JOB=> 361, NEXT_DATE=> TO_DATE('2010-09-06 21:18:27', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'SYSDATE
+ 45/86400', WHAT=> 'PK_MONITORS.SP_OVERDUE_JOB;', NO_PARSE=> TRUE); END;
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=> 376, NEXT_DATE=> TO_DATE('2010-09-06 21:18:12', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'SYSDATE
+ 45/86400', WHAT=> 'PK_MONITORS.SP_UPDATE_GROUP_DATA;', NO_PARSE=> TRUE); END;
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Thanks Manohar
|
|
|
|
|
|
| Re: Errors While Import. [message #474491 is a reply to message #474487] |
Mon, 06 September 2010 13:49  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
How many times do we have to say NEVER USE DBMS_JOB.ISUBMIT, it is for Oracle ONLY.
The procedure you have to use is SUBMIT.
Use it and you are no more supported.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
