An ora 1452 error says there are duplicate keys, hence you can't create a unique key. If it is a known, death be unto me if I am wrong, 100% fact that the unique key was valid in the original data, the first question I would ask is: Was this an import that is being run with commit=y ignore=y, aborted, then restarted without truncating the data? In a case like that, you would get duplicate rows.
If that is not the case, you could try creating an EXCEPTIONS table using the ?/rdbms/admin/utlexcpt.sql script. Then try to add the unique constraint using the extra clause: "exceptions into exceptions". The exceptions table will have the rowid's of the offending rows. You can then: select a,b,c,etc. from your_table where rowid in (select row_id from exceptions); > -----Original Message----- > > IMP-00017: following statement failed with ORACLE error 1452: > "CREATE UNIQUE INDEX "TTIITM009001$IDX1" ON "TTIITM009001" .... > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
