Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Snapshot too old, any way to disable consistency?
I have a long-running "select *" query--it takes hours to process all the records--and sometimes I get "snapshot too old" for some of the rows. Is there any way to convince Oracle that I really don't care about consistent reads here, just fetch the most recent data from that record? This is especially important because I'm considering enabling discrete transactions for the updates anyways, so these errors will become much more frequent.
greg Received on Sat Jul 10 1999 - 11:48:17 CDT
![]() |
![]() |