Error: ORA 1452
Text: cannot CREATE UNIQUE INDEX; duplicate keys found
-------------------------------------------------------------------------------
Cause: A CREATE UNIQUE INDEX statement specified one or more columns that
currently contain duplicate values. All values in the indexed colums
must be unique by row to create a UNIQUE INDEX.
Action: If the entries need not be unique, remove the keyword UNIQUE from the
CREATE INDEX statement, then re-execute the statement. If the entries
must be unique, as in a primary key, then remove duplicate values
before creating the UNIQUE index.
You may also want to take a look at ( [url]http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=130205.1[/url] )
Bookmarks