I recall that the first time I saw ORA-1555 I did not understand
how things worked.
My complaint to Oracle was that I was not using snapshots. :)
The terminology in the error message is less than straightforward.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On 6/3/05, Lex de Haan <lex.de.haan_at_naturaljoin.nl> wrote:
>
>
> you indeed don't understand how things work; you typically use *all*
> rollback
> segments to produce read consistency, depending on who changed the block.
> the
> only thing you achieve with SET TRANSACTION is that if you start making
> changes
> yourself, you will write undo information to the rollback segment of your
> choice.
>
> 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:50
> To: Lex de Haan
> Cc: oracle-l_at_freelists.org
> 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).
>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 10 2005 - 12:10:26 CDT
