Re: SQR error messages

[Chris Shelton <cshelton@INDIANA.EDU>]

You need to rerun the reports, and copy down the exact error messages and
numbers and forward the information to your Oracle DBA.  These are error
messages resulting from either a very long running query, or running
against a poorly configured database.

The first message probably is resulting from a sort operation that ran out
of temp space, or a table has expanded too large for the tablespace
storage parameters.

The second message indicates that your rollback segments need to be
increased in size, or that you need to add more of them.  If you can get
you query optimized to run faster, the likelihood of the second message is
significantly decreased.

On Thu, 6 Apr 2000, Arkadiy wrote:

> Recently while executing 2 SQR programs I received 2 unrelated error messages:
> 1. max extents ...
> 2. snapshot too old ...
> unfortunately I was not able to write down the full text of the messages. 
>Does anyone know what they mean based on that information?
> Thank you.
>

chris