Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Use of TEMP TS with INSERT
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