RBS not using

  • From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 3 Jun 2005 17:31:26 +0530

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)


Other related posts: