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" <JayMiller_at_TDWaterhouse.com> 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 <mccdba_at_hotmail.com> 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: mccdba_at_hotmail.com
> >
> > 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: ListGuru_at_fatcity.com (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: wbpass_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: JayMiller_at_TDWaterhouse.com
>
> 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: ListGuru_at_fatcity.com (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: wbpass_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Fri May 17 2002 - 08:43:19 CDT
