Re: 11g novalidate index creation

It worked! - still waiting (7 days now) on Oracle support.

On Thu, Jul 19, 2012 at 7:45 PM, Hemant K Chitale <hemantkchitale_at_gmail.com> wrote:
> Create the {non-unique} index first. Then add the constraint.
>
> On Jul 19, 2012 3:40 AM, "Johan Muller" <johan.muller_at_gmail.com> wrote:
>>
>> 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
>>
>>
>

-- 
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