Re: fetch across commits

From: Thirumurugan vadivelu <tvadivelu_at_infonautics.com>
Date: Mon, 07 Jun 1999 12:28:30 -0400
Message-ID: <375BF32E.EDBF2F61@infonautics.com>

Looks like some Other transaction has modified the same data that you were trying to Select and Commited. So the Rollback Segment from where your Query reads , is available for overwriting and that is the Reason for the

                                   Error.

Try to Schedule Other transactions at some other point of time or Perform Less commits in that Transaction.

-Thiru
Steve Haynes wrote:

> In article <37546CE8.FAA6153F_at_gwl.com>, Dogan Cibiceli <dcib_at_gwl.com>
> writes
> >I didnot. I got a 1555 ( snapshot too old) error when I fetched across
> >commits. (after couple of 10K rows)
> >
> Snapshot too old means rollbacks too small or
> poor program design. Take your pick.
> Steve
> --
> Please remove nospam from my address to Reply.
Received on Mon Jun 07 1999 - 11:28:30 CDT