My off the cuff response is "did you have direct=yes" set in
the parm file or on the command line?
IIRC this is basically the same as using the '/*+ APPEND *'
hint in an INSERT statement.
Jared
"Steve McClure" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/20/2003 03:13 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: what did I miss? -- nologging generating redo
Allright I have a developer that is loading a few gig of historical data,
that will only be used for a very short period of time. I wanted to avoid
dealing with all the redo this is going to create. I created a new
tablespace using the nologging option. The table and it's indexes were
created with the nologging option. Yet as the developer started his load,
using sqlloader, I got swamped with redo logs. The only problem this
presents is that we have a standby db that is located offsite, and at
times
when we have heavy redo activity the archiver processes swamp our
bandwidth.
So no harm was really done, except I have to manually transfer all those
archived logs. I am just wondering what I missed.
Thanks,
Steve
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steve McClure
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:
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).
