Try to drop this index and rebuild it. Rebuilding of bitmap index on a table having parallel degree > 1 was having problem in the past. Just try it , it might resolve your problem.
Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 05 Oct 2001 12:55:58 -0800 RE: perplexing plan?Hi List, Env :Oracle 8.0.5, HP/UX 11 Action : Tried to rebuild a corrupt partitioned index on a partitioned table, partitioned on date, having 230 mil rows. Problem : The db is continuously generating ORA 600-2126 followed by ORA600-4137 and ending in Db crash. Metalink has not been heplful. All the Rollback extents are showing negative nos. Now I cant get the db to run with Oracle Express. Even trying to login to Express form, crashes the db with the above said ORA600. Oracle Support has asked to rebuild the db. Is there any other way to do this ?? TIA Srini _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
