Or if you want the loaded data to be recoverable :) Also, you will find some nasty side affects when using direct sql load (indexes are invalidated at the end for rebuild). Of course you can use the skip_unusable_indexes parameter to get around concurrent query errors (this feature has been known to have bugs).
You may also want to consider loading into a table, building indexes, and then doing a partition exchange. Bill --- "Miller, Jay" <[EMAIL PROTECTED]> wrote: > And of course you shouldn't do this if you're > running with a standby > database. > > Jay Miller > > -----Original Message----- > Sent: Wednesday, May 15, 2002 5:28 PM > To: Multiple recipients of list ORACLE-L > > > Command line option DIRECT=Y > > Control file option UNRECOVERABLE > > --- dist cash <[EMAIL PROTECTED]> wrote: > > We have ORACLE 8.1.7.2 version running on SUn > > Solaris. The ORACLE running > > under "archive log mode". everytime we use > > Sql*loader to load data, it > > will generate a lot of "archive logs". Does their > > has way to make > > sql*loader run under "nologging" mode? > > > > Thanks. > > > > > > > > > _________________________________________________________________ > > MSN Photos is the easiest way to share and print > > your photos: > > http://photos.msn.com/support/worldwide.aspx > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: dist cash > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > 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!? > LAUNCH - Your Yahoo! Music Experience > http://launch.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Bill Pass > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > 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: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > 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!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
