Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: snapshot too old question
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