u have created the large rollback segment but u havn't made it online. issue the following command:-
alter rollback segment <segment_name> online;
issue the rollback or commit command
then issue the statment
set transaction use rollback segment<name>;

if u have any more queries contact me
all the best

shirish
[QUOTE][i]Originally posted by badrinathn [/i]
[B]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

[/B][/QUOTE]