Re: snapshot too old error
From: Carlos <miotromailcarlos_at_netscape.net>
Date: Tue, 1 Jun 2010 00:26:01 -0700 (PDT)
Message-ID: <694afa15-6aca-4e1b-9822-1004ecf188a8_at_k31g2000vbu.googlegroups.com>
On Jun 1, 3:08 am, "phil_herr..._at_yahoo.com.au" <phil_herr..._at_yahoo.com.au> wrote:
> This could be due to rollback space issues, or it could be due to
> delayed block cleanout, a fairly complex issue that Tom Kyte explains
> here:
>
> http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2...
>
> -- Phil
Date: Tue, 1 Jun 2010 00:26:01 -0700 (PDT)
Message-ID: <694afa15-6aca-4e1b-9822-1004ecf188a8_at_k31g2000vbu.googlegroups.com>
On Jun 1, 3:08 am, "phil_herr..._at_yahoo.com.au" <phil_herr..._at_yahoo.com.au> wrote:
> This could be due to rollback space issues, or it could be due to
> delayed block cleanout, a fairly complex issue that Tom Kyte explains
> here:
>
> http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2...
>
> -- Phil
Ah! The good old ORA-01555!
It's good to know that some things never change. Even in the all-new Oracle 11g with all these buzz and whistles!
Cheers.
Carlos. Received on Tue Jun 01 2010 - 02:26:01 CDT