Re: 11g novalidate index creation

  • From: Johan Muller <johan.muller@xxxxxxxxx>
  • To: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
  • Date: Fri, 20 Jul 2012 13:15:50 -0500

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


Other related posts: