Re: TEMP segments

[Tim Gorman]

...as does INSERT /*+ APPEND PARALLEL */... ----- Original Message ----- From: Fink, Dan To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 19, 2002 1:15 PM Subject: TEMP segments I just found a new command that creates TEMP segments. It is well known that index creations first create the index segments as TEMP segments then 'convert' them to index segments upon completion. What I just found out (thanks to a failed operation) is that 'CREATE TABLE AS SELECT' (ctas) also creates the segments as TEMP first.   Dan Fink