Nope. Under these circumstances you must run this query out-of-hours when
no DML is in conflict with your rbs...
Greg Stark <gsstark_at_mit.edu> wrote in article <87hfn86zcf.fsf_at_mit.edu>...
>
> 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 Tue Jul 13 1999 - 16:15:06 CDT
