Re: rollback segment errors

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Mon, 30 Sep 2002 08:21:50 +1000
Message-ID: <mWKl9.42665$g9.122787@newsfeeds.bigpond.com>

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:45qepuke5bna56mfh1eab5p0kldjqtnjiv_at_4ax.com...
> On Sun, 29 Sep 2002 20:16:13 GMT, Karen Abgarian <abvk_at_ureach.com>
> wrote:
>
> >Snapshot-too-old message is one on the most important ones
> >in oracle. It has to do with oracle's inability to build a so-called
> >read-consistent view required for the query.
>
> The ora-1555 occurs because Oracle *does* build a read-consistent view
> for the query. Any reason why you arrive at the opposite conclusion?
>

I think what was being said was: 'Oracle *needs* to build a read-consistent view for the query, but at some point it cannot do so, because someone else has over-written the rollback needed to accomplish this particular trick'.

I think you're both correct: Oracle *is* building a read-consistent view of the data, but at the point it discovers its inability to *continue* doing so, it bombs out.

Regards
HJR
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sun Sep 29 2002 - 17:21:50 CDT