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",
substr(sql_t
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.
'ORA-01
Are you sure enough to post an answer?
Alex Hillman
-Original Message-
Sent: Friday, August 17, 2001 2:45 AM
To: Multiple recipients of list ORACLE-L
Hi
In case of Temporary Tablespace the Initital segemnt and next segment should
be
equal to the sort_area_size parameter.
bye
G.Subrah
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
exten
I knew that this was incorrect answer - and instead of pointing that I asked
if he was sure.
Alex Hillman
-Original Message-
Sent: Saturday, August 18, 2001 1:06 PM
To: Multiple recipients of list ORACLE-L
Alex:
This is a fallacy that's been around since Oracle 6. In actuality, one
w