Re: Rollback Segments Errors

Larry,
Just one of those crazy Oracle things. You cannot change minextents once = created on RBS. Create a new RBS with minextents =3D 10 and then take the = old one offline and drop it when it's no longer being used.

Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438

>>> ltaylor_at_iq.com 11/09/00 11:25AM >>>

Why cant I change the minextents?

SVRMGR> alter rollback segment r05

     2> storage (minextents 10);
alter rollback segment r05
*
ORA-01570: MINEXTENTS must be no larger than the 4 extents currently allocated

SVRMGR> select
segment_name,tablespace_name,INITIAL_EXTENT,MIN_EXTENTS,MAX_EXTENTS

     2> from dba_rollback_segs
     3> where segment_name=3D'R05';
SEGMENT_NAME    TABLESPACE_NAME     INITIAL_EX  MIN_EXTENT MAX_EXTENT
------------------------------ ------------------------------ ----------
---------- ----------
R05                            RBS                               1048576