Re: HELP!! URGENT!! Need help on administration !! Oracle 7.3.2

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 8 Jan 1999 01:13:19 GMT
Message-ID: <369c5869.32758263@netnews.worldnet.att.net>

If your query is doing a sort, then the TEMP tablespace would be used. However, when the query was done, the space would be released.

Try restricting the WHERE clause of your query so that it returns fewer records. If that makes the error go away, then you just need to add more space to TEMP.

Jonathan

On Thu, 07 Jan 1999 12:59:09 GMT, t.klinger_at_mobilkom.at (Thomas Klinger) wrote:

>Help!
>
>I wanted to run a query (normally this one already worked) but my
>server gives back an error.
>
>ORA-1652: unable to extend temp segment by 4982 in tablespace TEMP
>
>This I understand but there are NO tables in our TEMPspace currently
>(looked with 'select * from all_tables where tablespace_name='TEMP';'
>as system).
>
>And there are still over 12000 blocks free! So, also the
>PERCENTAGE_INCREASE 50% is no prob. Diskspace enough, no data in
>TEMP-tablespace, enough space in the tablespace itself, the error
>happens each time.
>
>BTW: The query was already in use!
>
>Why?
>
>
>Kind regards
>
> Thomas Klinger
> Systemspecialist
>=======================================
>t.klinger_at_mobilkom.at
>http://www.mobilkom.at
>=======================================
>
>
Received on Thu Jan 07 1999 - 19:13:19 CST