Thank u! It worked! - still waiting (7 days now) on Oracle support. On Thu, Jul 19, 2012 at 7:45 PM, Hemant K Chitale <hemantkchitale@xxxxxxxxx> wrote: > Create the {non-unique} index first. Then add the constraint. > > On Jul 19, 2012 3:40 AM, "Johan Muller" <johan.muller@xxxxxxxxx> wrote: >> >> Here is the statement: >> >> >> C110219@tmc> ALTER TABLE keydb.ukid ADD CONSTRAINT ukid_uniq_doc >> UNIQUE(documentname25, documenttype, revision, sheet) >> USING INDEX(CREATE INDEX ukid_uniq_doc ON keydb.ukid(documentname25, >> documenttype, revision, sheet)) ENABLE NOVALIDATE; >> >> >> and the consistent result: >> >> ERROR at line 1: >> ORA-00600: internal error code, arguments: [kkdccui2], [], [], [], [], [], >> [], >> [] >> >> >> Filed an SR with via metalstink but not holding my breath. >> >> 11.2.02 on HP PA Risc 64 bit. >> >> Will go after SGA settings but are not holding my breath! >> >> There are 27 duplicates in 912933 roles (legacy data imported via SAP >> - whee!) and and index is needed to try and increase performance. The >> dupes cannot be deleted as there is one column that contains data that >> has to stay available. >> >> Any ideas? >> >> -- >> Johan Muller >> Oracle DBA >> 817 | 715 | 4813 or 817 | 247 | 0260 fax 817 | 523 | 4942 >> Text : 8177154813@xxxxxxxxxxx >> -- >> //www.freelists.org/webpage/oracle-l >> >> > -- Johan Muller Oracle DBA 817 | 715 | 4813 or 817 | 247 | 0260 fax 817 | 523 | 4942 Text : 8177154813@xxxxxxxxxxx -- //www.freelists.org/webpage/oracle-l