Re: Query from Oracle Reports caused temp tablespace to be full

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 01 May 2001 22:26:14 -0700
Message-ID: <3AEF9A76.90A47A3E@exesolutions.com>

Zeyad S wrote:

> Hi all,
> Has anyone had any similar problem with running a query from Oracle
> reports that cause the Temp tablespace to get full? The same query
> sometimes run in seconds without any problem and another time it caused
> the temp to be full with around 1GB. The records in the tables are
> really few and i dont expect any problem even if we have many joins.
>
> The error that we received is:
> ORA-01237 cannot extend datafile 4 '/data/...../temp01.dbf
> ORA-19502: write error on file '/data/...../temp01.dbf
>
> Any help will be appreciated.

Without seeing the SQL you are executing it is impossible to tell what is causing it. But my suspicion is that you are creating a Cartesian Product.

Daniel A. Morgan Received on Wed May 02 2001 - 00:26:14 CDT