RBS not using 2005-06-06 - By Lex de Haan
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
--
http://www.freelists.org/webpage/oracle-l
|
|
