Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating table in new tablespace

Re: Creating table in new tablespace

From: Steve Phelan <stevep_at_no-spam.pmcgettigan.demon.co.uk>
Date: 1997/07/10
Message-ID: <33C4D41F.58D48B09@no-spam.pmcgettigan.demon.co.uk>#1/1

bluebody wrote:

> I created a new tablespace and datafile and am trying to create a
> table in
> it by using a subquery from another table. I keep getting ORA-1652
> unable
> to extend temp segment by 102400 in tablespace xxxxxxx. The Action in
> the
> message manual says to add another datafile. I did this and still get
> the
> same error. How do I get around this error?

If it's a 'temp' segment - NOT a 'table' segment - look at the 'temporary tablespace' setting of the user you are creating the table under. Seems to me that that is where your problem lies, not in the actual new table's tablespace. You may have to change or increase the size of the temporary tablespace.

Steve Phelan. Received on Thu Jul 10 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US