11g novalidate index creation
- From: Johan Muller <johan.muller@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 18 Jul 2012 14:39:25 -0500
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
Other related posts:
