DBMS.JOB problem

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Mon, 17 May 1999 11:51:39 -0400
Message-ID: <37403B0B.BAAB718E@bigfoot.com>

I just created a brand new user on a brand new tablespace, and did a fromuser/touser
import. I got the following message:

IMP-00017 - following statement failed with ORACLE error 1: .... sys.dbms_ijob.submit......
IMP-00003 - ORACLE error 1 encountered
unique constraint (SYS.I_JOB_JOB) violated at SYS.DBMS_IJOB, line 113.

I suppose this is happening because you can only have unique job numbers at the instance level? So there are other jobs in the instance with the same number?

Is there a way around this or do jobs have to be re-submitted?

Thanks,
Dc. Received on Mon May 17 1999 - 10:51:39 CDT