Re: ORA-01555 error

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