| 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
![]() |
![]() |