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

Home -> Community -> Usenet -> c.d.o.server -> Re: Use of TEMP TS with INSERT

Re: Use of TEMP TS with INSERT

From: <fitzjarrell_at_cox.net>
Date: 27 Dec 2005 15:09:14 -0800
Message-ID: <1135724954.714580.29460@f14g2000cwb.googlegroups.com>

artmt_at_hotmail.com wrote:
> I am getting "unable to extend temp segment" for
> INSERT INTO TABLE_A SELECT * FROM TABLE_B.
> Both tables are in the same TS MY_DATA with indexes in the same TS
> MY_IDX.
>
> Why is it using temp ts?
>
> Thanks
> -Art

No, what you are seeing is:

unable to extend temp segment by xxx in tablespace YYYYY

Until the transaction is committed every segment created is a temporary segment, no matter which tablespace it is that you may be using. The temp segment mentioned in the error message is found in tablespace MY_DATA and you'll discover that when you read the *entire* error message, not simply the part you want to read.

Please pay more attention to the error messages in the future.

David Fitzjarrell Received on Tue Dec 27 2005 - 17:09:14 CST

Original text of this message

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