Re: RE: how to find INDEX CORRUPTION ???

Thans Rafiq.
The degree for the table is 1.

SQL > create index idx_mh_frommemno on msg_history ( frommemno );

this is what i did ?
either it's a bitmap or b-tree on this column (only) , it results in ORA-600.

i wonder why it happens so ?!
any clue !!

thanx once again.

Jp.

2003/04/03 5:54:54, "M Rafiq" <rafiq9857_at_hotmail.com> wrote:

>Drop the index and recreate it without parallel clause. If your table is
>having degree > 1 , then make it 1 and then recreate index. It looks a old
>bug for bitmap index on a table having degree > 1.
>
>Regards
>Rafiq

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).