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