Re: snapshot too old question

From: Yong Huang <yhuang_at_indigopool.com>
Date: Fri, 3 Nov 2000 16:29:36 -0600
Message-ID: <8tvee3$cbl$1@news.sinet.slb.com>

Are you sure you're not modifying that table? Check your v$transaction. You may have a transaction not rolled back or committed.

Yong Huang
yhuang_at_indigopool.com

<mr_potato_head_at_my-deja.com> wrote in message news:8ttkpd$jm1$1_at_nnrp1.deja.com...
> Hi,
> I'm running 8.1.6 on solaris 7 and I'm getting a "snapshot too old"
> on a table that is not being updated. I thought I could only get this
> error if the table was being updated and the rollback came around on the
> rollback segment and over wrote my files I needed for read consistency.
> Why would I get this error on a table that is just being "select"ed not
> being update? Thanks in advance...
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 03 2000 - 16:29:36 CST