| 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
The error has nothing to do with your temp tablespace. The problem is with
the stage_d tablespace. You need either larger extents or to allow a larger
number of extents. For example,
SQL> create table temp_tb
storage(maxextents 4096)
as
select * from tb_cnt;
If the storage requirements for this table are not inline with those of the other tables in the tablespace, you should consider placing the table in another tablespace.
You should also consider the unrecoverable option; i.e. "create table temp_tb unrecoverable ..." This will greatly increase the speed at which the table will be created. Please read up on this option -- now called nologging in Oracle 8.
Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu
-----Original Message-----
From: cemail_at_sprintmail.com [mailto:cemail_at_sprintmail.com]
Sent: Thursday, June 22, 2000 10:50 AM
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 Thu Jun 22 2000 - 19:41:02 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).
 |
 |