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_at_naturaljoin.nl> 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_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
>
>
>
--
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
Received on Fri Jun 03 2005 - 08:55:03 CDT
