Re: ORA-01555 error

Sybrand Bakker wrote:
> On 4 Dec 2005 14:19:23 -0800, "kwr2k" <Kanwar.Plaha_at_gmail.com> wrote:
>
> >Hi guys,
> >We have a long-running query (CTAS) that throws up ORA-01555. This is
> >the only query running against the database, which is Oracle9i
> >(9.2.0.6). Also, automatic undo is turned off on instructions from the
> >application vendor. Increasing the rollback tablespace makes this error
> >go away although the high water mark does not justify the increase in
> >tablespace size.
> >
> >My question is: What are all the possible causes of this error and what
> >can be done in each case?
> >
> >Thanks.
>
>
> Question: do you know how Google works? Yes? PLEASE, USE IT, before
> posting, This is a FAQ and the issue has been dealt with AD NAUSEAM!!!
>
> I would also recommend searching a different vendor. Disabling
> automatic undo is just utterly plain stupid.
>
> --
> Sybrand Bakker, Senior Oracle DBA

Don't know why I bother, but Mr. Bakker, if you're just going to slam someone, it's best not responding at all. Received on Mon Dec 05 2005 - 10:35:30 CST