Home » RDBMS Server » Server Utilities » Errors While Import. (HP-UX 10g)
Errors While Import. [message #474487] Mon, 06 September 2010 13:40 Go to next message
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 #474489 is a reply to message #474487] Mon, 06 September 2010 13:46 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You try to import a job with an ID that already exists in the database you import it into.
Re: Errors While Import. [message #474491 is a reply to message #474487] Mon, 06 September 2010 13:49 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Dynamic control file generation in WINDOWS Environment
Next Topic: CSV file as a Datafile in Sql*loader
Goto Forum:
  


Current Time: Thu Mar 28 17:45:40 CDT 2024