Unfortunately my source is another table. By the way (btw.), will " sqlldr direct=true" work with IOT?
"m.b" - may be. Igor Neyman, OCP DBA [EMAIL PROTECTED] -----Original Message----- Yong Huang Sent: Wednesday, November 05, 2003 12:25 PM To: Multiple recipients of list ORACLE-L I see. Sorry for misreading. How about direct path load? sqlldr direct=true. But this means your data source is on the filesystem. What is M.b.? Yong Huang --- Igor Neyman <[EMAIL PROTECTED]> wrote: > Yong, > > M.b. my question was not clear. > I know, "nologging" doesn't work with IOTs. > What I'd like to know, if there are any "tricks" (similar to > direct-path) to minimize undo/redo when inserting into IOT. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > > -----Original Message----- > Yong Huang > Sent: Wednesday, November 05, 2003 9:49 AM > To: Multiple recipients of list ORACLE-L > > Hi, Igor, > > Direct-path insert does not work for IOTs. This is documented in SQL > Reference > for INSERT. > > Whether it works for a table without NOLOGGING set (i.e. LOGGING) is not > clear > to me. Documentation says the table has to be NOLOGGING, or its > tablespace has > to be so. But Tom Kyte seems to show us that as long as you say INSERT > /*+ > APPEND */ SELECT, there won't be redo (except for the minimum data > dictionary > change), regardless of the table logging setting. See his demo at > http://groups.google.com/groups?selm=a3k2kp08q5%40drn.newsguy.com (that > message > was not intended to prove my observation). If somebody reads that > differently, > please correct me. > > Yong Huang > > --- Igor Neyman <[EMAIL PROTECTED]> wrote: > > As it was recently discussed, > > > > Insert /*+ append */ into <destination_table> select * from > > <source_table> > > > > will produce minimum redo/undo if <destination_table> specified as > > "nologging". > > > > > > But, what if <destination_table> is index-organized table? > > Is it possible to achieve the same results (in regards to amount of > > redo/undo)? > > > > Igor Neyman, OCP DBA > > [EMAIL PROTECTED] > > __________________________________ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Yong Huang > 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.net > -- > Author: Igor Neyman > 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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.net -- Author: Igor Neyman 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).