RBS not using

Hi all,
 I have got one problem. I am running a script in which my first statement 
is " SET TRANSACTION USE ROLLBACK SEGMENT RBS01;" but the script is throwing 
error as " ora-01555: snapshot too old. Rollback segment rbs02 too small" . 
Now the problem is why its throwing error on RBS02 when I have set my 
transaction to use RBS01? Any comments on this or any suggestion ?

-- 
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx

--
http://www.freelists.org/webpage/oracle-l

Other related posts: