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:

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2010

Added on Dec 2 2010

#database-key-features, #export-import-sql-loader-external-tables

2 comments

6,270 views