Re: Snapshot too old?

From: Yosi Greenfield <ygreenfield_at_compuserve.com>
Date: Tue, 26 Oct 1999 11:28:21 -0400
Message-ID: <3815C895.BFB8DCD9@compuserve.com>

This could mean you rollback segs are too small. That's like the standad answer. More likely, it means you're committing while fetching data with an open cursor. The commit releases the rollback still used by your query.

To solve, either 1) commit only once, at the end, or 2) at each commit, close your cursor and reopen it to query the as-yet unqueried rows.

HTH, Yosi

ropru_at_my-deja.com wrote:

> Can someone explain me please what could cause this message to appear:
>
> "Snapshot too old. Segment Data_Rd11 to small
>
> no rows selected"
>
> I am doing some changes to really complex query and I got this message.
>
> Thank you
>
> Roman
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 26 1999 - 10:28:21 CDT