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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).