11g novalidate index creation

From: Johan Muller <johan.muller_at_gmail.com>
Date: Wed, 18 Jul 2012 14:39:25 -0500
Message-ID: <CAKC1FKU_AdrGagV2GSC+Q+jrCsL+6DFFyebWaD_dd5waOgjPug_at_mail.gmail.com>



Here is the statement:

C110219_at_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_at_tmomail.net
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 18 2012 - 14:39:25 CDT

Original text of this message