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
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 systemcannot 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)27885841Received on Sun Dec 01 1996 - 00:00:00 CET