Re: Reducing rollback segment tablespace sizes

Michael Milligan wrote:
>
> I have a client where rollback segments were set up RBS01-RBS05, all in a
> tablespace called RBS. The person who set it up set %INCREASE at 50%. Well,
> I shrank the segments to themselves down to less than 500MB total from
> 4.6GB! But in using ALTER DATABASE DATAFILE . . . RESIZE . . . it won't let
> me resize it at all (it has extents scattered throughout). Anyone know how I
> go about shrinking it? Do I have to create a new tablespace/datafile, then
> drop the old one?
>
> TIA,
>
> Michael Milligan
> Oracle DBA
> Ingenix, Inc.
> 2525 Lake Park Blvd.
> Salt Lake City, Utah 84120
> wrk 801-982-3081
> mbl 801-628-6058
> michael.milligan_at_ingenix.com
>

Waow !!! A true, live Oracle 6 database ?

AFAIK, PCTINCREASE has been hard-coded to 0 for rollback segments since the beginnings of Oracle 7.

Concerning your question, it all depends on where your existing rollback segments are located in the datafile (look at dba_extents). All you have to do is drop and recreate each roolback segment in tirn.

Now, if this really is an Oracle6 database, RESIZE doesn't work ...

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).