Re: ORA-1555 snapshot too old: why?

joel garry wrote:
> DA Morgan wrote:
> > joel garry wrote:
> > >
> > > They would likely find Note:174782.1, tell him someone else was
> > > updating an object so Oracle wouldn't be able to make a read-consistent
> > > view of the data for exp, and to use consistent=n as a workaround.
> >
> > I looked for that and didn't find it. You obviously used better
> > search criteria than I.
>
> KISS: ora-1555 consistent=Y

Apologies! A slightly different search: ora-1555 consistent=N

They both give 3 answers, but not exactly the same 3 (and I was just looking at the first few numbers of the notes). :-/

jg

-- 
@home.com is bogus.
http://www.rubemachine.com/