Re: Rollback segment error

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 21 Dec 1999 22:22:10 GMT
Message-ID: <385ff80c.473417197@news.eagles.bbs.net.au>

Hello,

There is a tip on my web site (1st URL below) on how to avioid this error.

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.com.au/

On Fri, 17 Dec 1999 06:09:12 GMT, ckchan5_at_my-deja.com wrote:

>I have the following error during select data from the table process.
>
>ERROR:
>ORA-01555: snapshot too old: rollback segment number 1 with name "R05"
>too small
>
>I tried to fine tune the sql statement, but still getting the same
>error message.
>
>Is there any way I can overcome this error without modify my existing
>sql statement.
>
>Regards
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Dec 21 1999 - 16:22:10 CST