Home » RDBMS Server » Server Administration » unable to drop rollback segment
unable to drop rollback segment [message #52057] Sun, 30 June 2002 21:29 Go to next message
Vishweshwara Bhat
Messages: 6
Registered: June 2002
Junior Member
Please furnish the clarification to the following problem.

I have one rollback segmnent r06, one block of this rollback segment is corrupted and I am unable to drop this rollback segment.
How to drop this rollback segment please advice.

Report message to a moderator

Re: unable to drop rollback segment [message #52069 is a reply to message #52057] Mon, 01 July 2002 07:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
A rollback segment should be offline, before it can be dropped.
Is the concerned RBS offline?
If so, what is the error?

Report message to a moderator

Re: unable to drop rollback segment [message #52091 is a reply to message #52057] Tue, 02 July 2002 06:13 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
Hi !

If you can't take the rbs offline, and if the RBS is really corrupted. You can use the parameter init.ora
_CORRUPTED_ROLLBACK_SEGMENTS=( segment_list )
shutdown normal or immediate, restart the database and drop the rbs. modify the init and restart the database.

Report message to a moderator

Previous Topic: can one resize the system tablespace
Next Topic: rollback segment for compute statistics
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 20:32:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.