Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: what did I miss? -- nologging generating redo

RE: what did I miss? -- nologging generating redo

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Fri, 21 Mar 2003 09:26:57 -0500
Message-Id: <24738.322699@fatcity.com>


You must use the direct path insert in order to use the nologging option. use sqlldr with direct=y

Stephane

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Steve McClure
Sent: Thursday, March 20, 2003 6:14 PM
To: Multiple recipients of list ORACLE-L 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: smcclure_at_usscript.com

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: 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 Mar 21 2003 - 08:26:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US