It works perfectly fine for me!!
Code:SQL> CREATE PUBLIC ROLLBACK SEGMENT RBS01 TABLESPACE RBS STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 10 MAXEXTENTS 505); Rollback segment created. SQL> CREATE PUBLIC ROLLBACK SEGMENT "RBS02" TABLESPACE RBS STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 10 MAXEXTENTS 505); Rollback segment created. SQL> select segment_name,MIN_EXTENTS,MAX_EXTENTS from sys.dba_rollback_segs; SYSTEM 2 505 RBS0 8 4096 RBS1 8 4096 RBS2 8 4096 RBS3 8 4096 RBS4 8 4096 RBS5 8 4096 RBS6 8 4096 RBS7 8 4096 RBS01 10 505 RBS02 10 505 11 rows selected.




Reply With Quote