Re: Please Help !!!

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Fri, 05 Oct 2001 13:35:10 -0700
Message-ID: <F001.003A3F03.20011005134022@fatcity.com>

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: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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: rafiq9857_at_hotmail.com

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: 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). Received on Fri Oct 05 2001 - 15:35:10 CDT