Re: rollback segs question

Mark,
Larry was asking if the tablespace can be dropped, not the segments.

In article <19981014182252.27305.00000363_at_ng-cr1.aol.com>,   markp28665_at_aol.com (MarkP28665) wrote:
> 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 -
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 15 1998 - 12:19:26 CDT