>Subject: Re: rollback segs question
>From: markp28665_at_aol.com (MarkP28665)
>Date: 10/14/98 5:22 PM Central Daylight Time
>Message-id: <19981014182252.27305.00000363_at_ng-cr1.aol.com>
>
>From: "Larry Schenavar" >>
>Can a rollback tablespace be dropped and
>rebuilt without any serious problems with the database? <<<
>
>Yes, you can alter the segments offline, drop them, and re-create them. You
>should probably take only one rbs segment away from the system at a time.
>
>If the Oracle instance should crash or be stopped after a segment is dropped,
>but before it is re-created you may need to modify the init.ora before you
>can
>restart the database if you use private rollback segments.
>
>With version 7.3+ you can use the alter rollback segment shrink command to
>give
>up unused allocated extents. You should check to see if you have the optimal
>parameter set. By setting this parameter you can pretty much get Oracle to
>keep free extents available to whichever segment needs them.
>
>Mark Powell -- Oracle 7 Certified DBA
>- The only advice that counts is the advice that you follow so follow your
>own
>advice -
>
>
>
>
>
>
>
Received on Wed Oct 14 1998 - 18:22:19 CDT
