How to increase rollback segment
hi,
I am using oracle8i in solaris
I got a situation to increase rollback segment but i dont know how to do so?
can any one help me in solving this..........
I also want to know wat is the maximum max_extents size we can keep.....
This is my rollback segments
SQL> select segment_name, max_extents,TABLESPACE_NAME FROM dba_rollback_segs;
SEGMENT_NAME MAX_EXTENTS TABLESPACE_NAME
------------------------------ --------------- ------------------------------
SYSTEM 121 SYSTEM
RBS 121 SYSTEM
RBS1 121 RBS
RBS2 121 RBS
RBS3 121 RBS
RBS4 121 RBS
RBS99 32765 RBS1
7 rows selected.
With Regards
Boo