Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Rollback Segments Errors

Rollback Segments Errors

From: Larry Taylor <ltaylor_at_iq.com>
Date: Thu, 9 Nov 2000 09:21:15 -0800
Message-Id: <10675.121606@fatcity.com>


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='R05';
SEGMENT_NAME    TABLESPACE_NAME     INITIAL_EX  MIN_EXTENT MAX_EXTENT
------------------------------ ------------------------------ ----------
---------- ----------
R05                            RBS                               1048576
3                1000


Thanks in advance. Received on Thu Nov 09 2000 - 11:21:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US