Re: select e rollback segment

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Wed, 24 Apr 2002 15:24:04 GMT
Message-ID: <3CC6CE02.563E0E28@exesolutions.com>

Renato wrote:

> the query with a SELECT statement use the rollback segment? I execute a
> query on Oracle 7.3.4 and the programme gave me the error: "snapshoot too
> old: rollback segment NAME too small (ORA 01555)"

Your rollback segments are either too small or too few in number.

The older content of the rollback segment is being over-written by another transaction while your transaction is still running.

Either make the existing rollback segments larger so that there is more time before overwriting or create more segments so that new transactions will have a rollback segment of their own. I'd try enlarging first as it will more likely solve the problem.

Daniel Morgan Received on Wed Apr 24 2002 - 10:24:04 CDT