works and generates redo -----Original Message----- Sent: Wednesday, November 05, 2003 2:04 PM To: Multiple recipients of list ORACLE-L
Yes, direct-path load works on IOTs, at least in 9.2 running in Solaris 2.8. Yong Huang --- Igor Neyman <[EMAIL PROTECTED]> wrote: > 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). __________________________________ 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: Khedr, Waleed 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).
