Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Rollback Segments Errors
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