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
This is the part of the SQL where Oracle needs temp space for.
It writes the results of the select to a temporary work area so
that it can then sort it.
Your solution is found in the action part of the documentation on
the error.
,----[ From:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76999/e1500.htm#1003914
]
| ORA-01658 unable to create INITIAL extent for segment in
| tablespace string
|
| Cause: Failed to find sufficient contiguous space to allocate
| INITIAL extent for segment being created.
|
| Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space
| to the tablespace or retry with a smaller value for INITIAL.
`----
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Galen Boyer
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
