Are you doing this in pl/sql? alter session then cursor loop dml here on your cursor end loop -- -- Original Message -- -- From: "Onkar N Tiwary" <onkarnath.tiwary@(protected)> To: "Lex de Haan" <lex.de.haan@(protected)> Cc: <oracle-l@(protected)> Sent: Friday, June 03, 2005 8:50 AM Subject: Re: RBS not using
> Lex/Dennis, > Thanx for the suggestion but my main query is why my transaction is not > using RBS01 when I have set the same for the current transaction?? No doubt > u guys are absolutely right but when I am setting the transaction to use > RBS01 then it should use that only and not the other rollback segment(if I > am not wrong). > > On 6/3/05, Lex de Haan <lex.de.haan@(protected)> wrote: > > > > > > the error is unrelated to the SET TRANSACTION statement. the error simply > > means > > that Oracle is not able to provide a read-consistent image of the data you > > access in the script, probably caused by *other* transactions > > simultaneously > > running on the same database, making changes to the database, and > > committing > > those changes. Those *other* transactions are apparently using rollback > > segment > > RBS02, and apparently that rollback segment is quite small -- so it gets > > overwritten in a cyclic way. You probably have a heavy, long-running query > > in > > your script? > > > > hope this helps, > > kind regards, > > > > Lex. > > > > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --- > > Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html > > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --- > > > > -- --Original Message-- -- > > From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] > > On > > Behalf Of Onkar N Tiwary > > Sent: Friday, June 03, 2005 14:01 > > To: oracle-l@(protected) > > Subject: 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 (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 ? > > > > -- > > Thanks & Regards, > > T. Onkar Nath > > Ph : +91-9826728111(Cell) > > to_onkar@(protected) > > onkarnath.tiwary@(protected) > > > > -- > > http://www.freelists.org/webpage/oracle-l > > > > > > > > > -- > Thanks & Regards, > T. Onkar Nath > Ph : +91-9826728111(Cell) > to_onkar@(protected) > onkarnath.tiwary@(protected) > > -- > http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l
