Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user9972431Dec 2 2010 — edited Dec 3 2010
Hi,
RDBMS: 10.2 standard
I am using impdp to import schema. I have first dropped the schema , re create schema and done all grants.
But I am having the given below error message. The user hold a job.As I have dropped schema ,ideally job have to drop too.

ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated Failing sql is:
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2010
Added on Dec 2 2010
2 comments
6,269 views