Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: snapshot too old question

Re: snapshot too old question

From: Brian McKerr <bmckerr_at_hotmail.com>
Date: Fri, 3 Nov 2000 19:43:53 +1000
Message-ID: <8tu1cr$bvb$1@corolla.OntheNet.com.au>

The *tablespace* is being backed up (hot backup mode for example), any object in that tablespace can cause this error.

Cheers,

BM.

"W³asiuk Krzysztof" <wlasiukk_at_prokom.pl> wrote in message news:8ttupp$ori$1_at_korweta.task.gda.pl...
> isn't this error bind to transaction ? (not to table or any other object)
>
> U¿ytkownik <mr_potato_head_at_my-deja.com> w wiadomo¶ci do grup dyskusyjnych
> napisa³: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 - 03:43:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US