Re: Help ! Problems with TEMP tablespace

Matthieu Exbrayat wrote:

> 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?

  You need increase the size of your temporary tablespace by using:

  ALTER TABLESPACE temp ADD DATAFILE 'xxx' SIZE xxM.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841