And again... same result
Code:
CREATE PUBLIC ROLLBACK SEGMENT RBS04
TABLESPACE RBS3
STORAGE ( INITIAL 512 NEXT 512K MINEXTENTS 10 MAXEXTENTS 400)
rollback-segment created.
SQL> select segment_name,MIN_EXTENTS,MAX_EXTENTS
from sys.dba_rollback_segs;
SEGMENT_NAME MIN_EXTENTS MAX_EXTENTS
------------------------------ ----------- -----------
SYSTEM 2 505
RBS0 8 8192
RBS1 8 8192
... etc etc...
RBS8 8 8192
RBS9 8 8192
SEGMENT_NAME MIN_EXTENTS MAX_EXTENTS
------------------------------ ----------- -----------
RBS03 1 32765
RBS02 1 32765
RBS04 1 32765
I'm confused...
Last edited by efrijters; 12-04-2003 at 08:26 AM.
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.