Re: Rollback segment error

From: Ari Kaplan <akaplan_at_interaccess.com>
Date: Fri, 17 Dec 1999 01:03:15 -0600
Message-ID: <s5jo34alqrs184@corp.supernews.com>

The problem is that your rollback segments are too small. The ORA-1555 really has to do with rollback segments ; "snapshot" is a misnomer. Increase the NEXT size for your rollback segments.

Best regards,

-Ari Kaplan
Independent Oracle DBA
For 350 Oracle tips, visit http://homepage.interaccess.com/~akaplan

---

---

ckchan5_at_my-deja.com wrote in message <83ck26$57t$1_at_nnrp1.deja.com>...
>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 Fri Dec 17 1999 - 01:03:15 CST