Skip to Main Content

SQL & PL/SQL

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!

How find duplicate keys found when error ORA-01452: cannot CREATE UNIQUE INDEX;

Cac47Aug 14 2015 — edited Aug 14 2015

Hi Gurus,

I've fall within this stupid error

"cannot CREATE UNIQUE INDEX; duplicate keys found"


The issue is the Unique Index key is composed by multiple columns

CREATE UNIQUE INDEX KEY001AUTORISATIONS_APPORT ON TFT_AUTORISATIONS_APPORT

(AUT_APPORTEUR, AUT_AGENCE, AUT_PRODUIT, AUT_OPTION, AUT_TARIF, AUT_DATE_AUTORISATION)

TABLESPACE KEYS_TFT NOPARALLEL NOLOGGING

Now,

My issue is, how to find duplicates keys that are blocking this Index creation?

Thanks if you can help

This post has been answered by Jayam on Aug 14 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2015
Added on Aug 14 2015
2 comments
584 views