Re: ora-1555, order by, x, kyte

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<407277cc$0$3306$ed9e5944_at_reading.news.pipex.net>...
> "Paul" <pkelley_at_coat.com> wrote in message
> news:473377b4.0404051228.68ac9624_at_posting.google.com...
> > Alrighty, then,...
> >
> > In late February 2004, "X" posted some notes from metalink re using
> > "order by" to dodge ora-1555. He was lambasted in this group.
>
> I can't see this discussion on Google, is there a link to it?
>
> This one I did find, unfortunately I can't tell if the situations are the
> same in the two cases. Providing some actual information might help.
>
> cheers

I searched groups for "oracle snapshot too old sort" without the quotes and picked the link for the post from late feb from a thread with 39 posts.

This link worked when I tried it a few minutes ago.

http://groups.google.com/groups?q=oracle+snapshot+too+old+sort&hl=en&lr=&ie=UTF-8&scoring=d&selm=403e6a81%240%2422392%24626a14ce%40news.free.fr&rnum=3

The initial posting in oracle.misc included code that fetched across commits. The asktom thread was started by a broad question that didn't include a code example. Received on Tue Apr 06 2004 - 13:13:35 CDT