Brad,

Since you are using Oracle 7.3, use can use the SHRINK option to remove excess
rollback space and shrink them back to their optimal size.

First, the OPTIMAL clause must be set for your rollback segments. This should be set
to the size you would like the rollback segments to normally be.

Second, issue a command such as:

ALTER ROLLBACK SEGMENT rbs07 SHRINK;

Good luck!

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 105+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

: I am running Oracle Server 7.3 on WinNT 4.0.  I have an application trying
: to update 1 field each in 500,000 rows.  After about 10 minutes, I receive
: an error saying I'm out of rollback space.  5 of the 15 rollback segments
: are maxed out (a total of 30 mb).  How can I clear those 5 rollback
: segments?
: 
: Brad

Back to Ari Kaplan's Home Page Ari Kaplan's Home Page