Re: Help ! problems with temp file

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1997/01/28
Message-ID: <5cku6f$3ib@newton.pacific.net.sg>#1/1

Matthieu Exbrayat <exbrayat_at_lisiflory.insa-lyon.fr> wrote:
>--
>
>Hello,
>
>I try to realize a query on my oracle base.
>This query is made of 4 joins concerning about 10 000 tuples.
>The answer is about 10 tuples.
>Unfortunately, I receive the following answer :
>
>"ORA-01658: unable to create INITIAL extent for segment in tablespace
>TEMP"
>
>I feel quite uncomfortable, as it wasn't happening in the beginning
>of the day...
>
>I have been testing some proC programs, and sometimes I had to kill
>them. Could it have polluted the temp file?
>
>Is there anyway to clean it or enlarge it?
>
>I must tell you that our DBA is on holidays...
>
>All help Welcome!!!!

Hi there,

Your TEMP tablespace is so fragmented and it is not able to find a single chunk of contiguous space. You can coalesce the temp tablespace and try your query. If it does'nt work, you need to add a datafile to your temp tablespace. An immediate solution is to change USERS'S temporary tablespace to a another tablespace (which has got lot of free space).

Regards

N.Prabhakar Received on Tue Jan 28 1997 - 00:00:00 CST