Alex:
This is a fallacy that's been around since Oracle 6. In actuality, one
wants to set the initial and next extents of a temporary tablespace to
the same size as the size of the average sort in memory to ensure that
most disk sorts can be accommodated within a single temporary tablespace
Hello all,
I have a strage error.
'ORA-01658: unable to create INITIAL extent for segment in tablespace TEMP'. The
clients TEMP tablespace is 200M. The sql is:-
SELECT a.username, length(sql_text),
substr(sql_text,1,100) as SQL TEXT,
substr(sql_text,101,250) as Second TEXT,
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
'ORA-01658: unable to create INITIAL extent for segment in
tablespace TEMP'.
This is saying that Oracle is trying to use the TEMP tablespace
for some, temporary work, but it can't gain control of anymore
space.
[...]
ORDER BY executions desc
Hi
In case of Temporary Tablespace the Initital segemnt and next segment should
be
equal to the sort_area_size parameter.
bye
G.Subrahmanyam
-Original Message-
Sent: Thursday, August 16, 2001 8:28 PM
To: Multiple recipients of list ORACLE-L
Hello all,
I have a strage error.