Re: Help ! Problems with TEMP tablespace

Matthieu Exbrayat 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!!!!
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~ Matthieu EXBRAYAT | ~
> ~ LISI - INSA Lyon | e-mail : exbrayat_at_lisiflory.insa-lyon.fr ~
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This usually means that you need to add a datafile to your temporary tablespace.

John Hough Received on Mon Jan 27 1997 - 00:00:00 CST