Oracle is reporting that it cannot create a UNIQUE INDEX on the table
because it found duplicate records while trying to create the index.
You know have to find the duplicate values. This month I provide three methods
for locating duplicate rows in a table.

Method #1 uses a self-join query. Oracle tables always have one guaranteed
unique column, the rowid column. Use of the MIN and MAX functions against
the rowid column can easily display the duplicate rows.

Method #2 uses a GROUP BY / HAVING query on the table.

Method #3 uses the "exceptions into" clause of the alter table command. In order
to use the "exceptions into" clause, you will need to first create the EXCEPTIONS
table by running the script "utlexcpt.sql". On NT, this script is in your
ORACLE_HOME/rdbms(73/80)/admin directory: On UNIX, it is in
$ORACLE_HOME/rdbms/admin directory.

All articles, scripts and material located at the Internet address of http://www.idevelopment.info is the copyright of Jeffrey M. Hunter
and is protected under copyright laws of the United States. This document may not be hosted on any other site without my express,
prior, written permission. Application to host any of the material elsewhere can be made by contacting me at jhunter@idevelopment.info.

I have made every effort and taken great care in making sure that the material included on my web site is technically accurate,
but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from
relying on it. I will in no case be liable for any monetary damages arising from such loss, damage or destruction.