Read Jeremiah Wilton's great paper=20 http://www.speakeasy.org/~jwilton/oracle/snapshot-too-old.html In a nutshell, your transaction is using blocks that were modified by ANOTHER process.
Dennis Williams
On 6/3/05, Onkar N Tiwary <onkarnath.tiwary@(protected)> wrote: > Hi all, > I have got one problem. I am running a script in which my first statemen= t > is " SET TRANSACTION USE ROLLBACK SEGMENT RBS01;" but the script is throw= ing > error as " ora-01555 (See ora-01555.ora-code.com): 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 ? >=20 > -- > Thanks & Regards, > T. Onkar Nath > Ph : +91-9826728111(Cell) > to_onkar@(protected) > onkarnath.tiwary@(protected) >=20 > -- > http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l
