Message-Id: <10537.110265@fatcity.com> From: "Jeffrey Beckstrom" Date: Fri, 23 Jun 2000 10:32:03 -0400 Subject: Re: Temp Segment max extent reached There is no storage clause on the new table so it would be taking the = tablespace's defaults. >>> "Eric Lansu" 6/23/00 7:34:09 AM >>> What's the default-TEMP-tablespace for the user executing the command set to? It looks like it is STAGE_D in stead of TEMP. You are selecting from a view? so it may be creating some joined temp-table before actually filling up the temp_tb table. Eric Lansu ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" Sent: Thursday, 22 June 2000 19:49 > > 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? > > > ----- > Sent using MailStart.com ( http://MailStart.Com/welcome.html ) > The FREE way to access your mailbox via any web browser, anywhere! > > -- > Author: > INET: cemail@sprintmail.com=20 > > 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: ListGuru@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). --=20 Author: Eric Lansu INET: eric.lansu@quicknet.nl=20 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: ListGuru@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).