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!

impdp failing with ORA-00001: unique constraint (SYS.PK_COL_GROUP_USAGE$) violated

KirtikumarFeb 20 2017 — edited Feb 21 2017

Hi,

We are getting below error everytime we import data in the database through impdp.

BRPP_SCHEMA.SYS_C0015216 : sqlerrm = ORA-20000: Unable to set values for index SYS_C0015216: does not exist or insufficient privileges

Importing statistics failed for 1 object(s);

BRPP_SCHEMA.SYS_C0015216 : sqlerrm = ORA-20000: Unable to set values for index SYS_C0015216: does not exist or insufficient privileges

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.STATS_LOAD [MARKER]

MARKER

ORA-00001: unique constraint (SYS.PK_COL_GROUP_USAGE$) violated

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105

ORA-06512: at "SYS.KUPW$WORKER", line 11265

And the index SYS_C0015216 is not created. We have to manually create the index after import. Is this a bug?

Did someone faced this issue?

Regards,

Muzammil Ansari

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 21 2017

Added on Feb 20 2017

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

7 comments

3,044 views