Message-Id: <10537.110235@fatcity.com> From: "Eric Lansu" Date: Fri, 23 Jun 2000 12:31:04 +0200 Subject: Re: Temp Segment max extent reached 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 ----- From: To: "Multiple recipients of list ORACLE-L" Sent: Thursday, 22 June 2000 19:49 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? > > > ----- > 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 > > 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).