Re: ORA-01555 snapshot too old in Oracle 8.1.7

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 28 Feb 2003 08:19:08 -0800
Message-ID: <3E5F8BFC.6CEC871B@exesolutions.com>

Andrei Romazanov wrote:

> Hello all,
>
> after the conversion 8.0.5 - > 8.1.7 I get error Ora-01555 snapshot too
> old: roll-bake segment...
> in the situation, where in former times everything ran perfectly.
>
> Is it
> 1. Coincidence? (the size of the snapshot has just now the critical limit
> exceeded)
> 2. error in the settings?
> 3. bug in 8.1.7?
>
> Thank you in advance
> Andrei

In addition to the other comments make sure that you have the same number of rollback segments as before, that they are the same size, and most importantly ... that they are all online.

Daniel Morgan Received on Fri Feb 28 2003 - 10:19:08 CST