Ur problem is that the rollback segment u created is offline and should be brought online for use.In Oracle whenever u create a rollback segment it is offline by default.So u have to bring it online in order to use it.
The following syntax will bring the rollback segment online.
SQL>ALTER ROLLBACK SEGMENT <segment_name> ONLINE;
U can place the name of the rollback segment in ur init.ora parameter file
ROLLBACK_SEGMENTS=(rbs1,rbs2,rbs3) and restart the instance.
If u do so then when ur database is started the named rollback segments will automaically be brought online,instead of bringing them online each one-by-one
If u have any doubts,please be free to ask me at
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
[QUOTE][i]Originally posted by badrinathn [/i]
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
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