Okay, it's early here, I'm fuzzy. I think I meant the same thing (I'd had one of those "user calls" in the middle of the night)
what I think I meant to say was that any operation that would end up adding blocks above the HWM if it COMPLETED would do it by creating TEMP segments that are converted to data blocks on commit of the operation. basically, temp segments are created for any operation that does not touch existing blocks or am I still fuzzy? --- Tim Gorman <[EMAIL PROTECTED]> wrote: > No, only the original SQL*Loader DIRECT=TRUE does that (adding blocks > above > HWM), which was introduced with v7.0.x... > > Since then, all direct-path (a.k.a. append) operations (including > SQL*Loader > DIRECT=TRUE PARALLEL=TRUE, parallel CREATE INDEX, parallel CREATE > TABLE AS > SELECT, and INSERT /*+ APPEND PARALLEL */, etc) have created > temporary > segments for each parallel execution "slave" process which will be > merged > into eventual segment. As Anjo commented, it makes for really fast > and easy > rollback; just let SMON clean up the temporary segments... > > ...don't know if it's ever really been documented; I did include > this > description in our books on data warehousing in 1997 and 1999... > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, November 20, 2002 4:08 AM > > > > Tim -- that adds new blocks above the HWM? > > > > I wonder if any command that adds new blocks (vs inserting rows > into > > existing ones) automatically creates the new blocks as TEMP > segments. > > Logically it makes sense but I wonder if it's documented anywhere. > > > > > > > > --- Tim Gorman <[EMAIL PROTECTED]> wrote: > > > ...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 > > > > > > > > > __________________________________________________ > > Do you Yahoo!? > > Yahoo! Web Hosting - Let the expert host your site > > http://webhosting.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting > services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tim Gorman > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus – Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
