Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RBS not using
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.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On
Behalf Of Onkar N Tiwary
Sent: Friday, June 03, 2005 14:01
To: oracle-l_at_freelists.org
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: 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_at_yahoo.com
onkarnath.tiwary_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 06 2005 - 02:46:28 CDT