Re: Alter Rollback(RBS) tablespace

From: <satar_at_my-dejanews.com>
Date: Wed, 18 Nov 1998 21:18:35 GMT
Message-ID: <72vdio$or0$1@nnrp1.dejanews.com>

No, you do not need to take the rollback segments offline.

If you want to increase the Maxextent of a rollback segment: ALTER ROLLBACK SEGMENT "R04" STORAGE ( MAXEXTENTS 256 ); If you want to increase the default parameter of a rollback segment: ALTER TABLESPACE "RBS" DEFAULT STORAGE ( MAXEXTENTS 256 ); By the way, this is the parameter used when you create a rollback segment and do not specify a MAXEXTENT for the rollback segment.

If you want to resize the Roll Back Tablespace: ALTER DATABASE DATAFILE '/u01/oradata/y2k/rbs01.dbf' RESIZE 600M;

Please note that these are example settings.

Take Care and Good Luck,
Satar

In article <byrd-1811981236340001_at_mscfadm6.med.upenn.edu>, byrd_at_mscf.med.upenn.edu (Karen Byrd) wrote:
> I'm fairly new to doing DBA work.
>
> I need to adjust my rollback tablespace by increasining its size
> and maxextents. I assume the safest way to handle this is to:
>
> 1) take my rollback segs offline
> 2) use 'alter tablespace' to adjust my RBS tablespace
> 3) put my rollback segs online
>
> I am correct in my assumption.
>
> --
> Karen Byrd
> School of Medicine, Univ of PA
> Information Services
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 18 1998 - 15:18:35 CST