hi,

I have just now created a larger rollback segment to handle a bulk deletes.

I issued this command


SQL> create public rollback segment
large_rbs tablespace RBS
STORAGE
(INITIAL 10M
NEXT 5M
MAXEXTENTS UNLIMITED)

Rollback segment created.

SQL> set transaction use rollback segment large_rbs;
set transaction use rollback segment large_rbs
*
ERROR at line 1:
ORA-01598: rollback segment 'LARGE_RBS' is not online

HOW DO I BRING THIS LARGE_RBS ONLINE;
badrinath