Re: SQL*NET tablespace temp

From: Lun Wing San (Oracle) <"Lun>
Date: 1996/12/01
Message-ID: <32A1F161.4E42_at_qrcsun.qrc.org>#1/1


George Zolla wrote:
> "ORA 01652 unable to extend temp segment by 128 in tablespace TEMP"

  This error raised when:

1. The tablespace cannot allocate enough space for the segment.
2. The segment reaches the MAXEXTENT.
3. The segment uses unlimited option or maximum MAXEXTENT but the operating system 
cannot afford higher maximum extent.

For the situation one, you can add an additional datafile. For the situation two, alter tablespace storage clause to increase the MAXEXTENT. For the situation third, drop the tablespace and recreate it with greater INITIAL.

NB: For the temporary segment, all storage settings are inherited from the assoicated tablespace.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841
Received on Sun Dec 01 1996 - 00:00:00 CET

Original text of this message