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

Have you analyzed table msg_history with cascade structure option? do you find any message in alert_log for any possible corruption. You index is b-tree index as per syntax....

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Wed, 02 Apr 2003 17:18:36 -0800

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



_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: M Rafiq
  INET: rafiq9857_at_hotmail.com

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