| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Temp Segment max extent reached
Actually this is a weird oracle messgae, which sometimes mislead new DBA's
It is not bombing out on TEMP , but it is trying to create temp segment
in STAGE_D and reaching the max extents.
Look for the storage parameters of STAGE_D. You are right temp tablespace
is only 0.031m because this query shoud not even look at temp tablespace.
It will create temp segments in STAGE_D and finally rename them to actual
table
i.e TEMP_TB
Cheers
-----Original Message-----
From: cemail_at_sprintmail.com [mailto:cemail_at_sprintmail.com]
Sent: Thursday, June 22, 2000 1:50 PM
To: Multiple recipients of list ORACLE-L
Subject: Temp Segment max extent reached
Please help. I am trying to create a table based on a select from another table. There is 2000MB in the TEMP tablespace and maxextents is set to unlimited. I am getting this error after running the query:
SQL> create table temp_tb as
2 select * from tb_cnt;
select * from tb_sfa_prsbr_brand_rx_cnt
*
ERROR at line 2:
ORA-01630: max # extents (1017) reached in temp segment in tablespace
STAGE_D
The TEMP tablespace only fills to .031M before it chokes. How
can I fix this?
-- Author: INET: cemail_at_sprintmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing ListsReceived on Fri Jun 23 2000 - 08:09:48 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).
 |
 |