Oracle Database Discussions

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-01452

829857Apr 2 2012 — edited Apr 2 2012

Hi,
iam creating unique index on this table with 3 columns

CREATE UNIQUE INDEX UK_W_PRODUCT_D_TL ON W_PRODUCT_D_TL
(LANGUAGE_CODE
,INTEGRATION_ID
,DATASOURCE_NUM_ID)

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

Please tell me how to find the duplicate key and delete it.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2012

Added on Apr 2 2012

#general-database-discussions

3 comments

412 views