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 -> Use of TEMP TS with INSERT

Use of TEMP TS with INSERT

From: <artmt_at_hotmail.com>
Date: 27 Dec 2005 14:53:00 -0800
Message-ID: <1135723980.219688.161950@g43g2000cwa.googlegroups.com>


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 Received on Tue Dec 27 2005 - 16:53:00 CST

Original text of this message

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