RE: Turning off redo logging

From: Rajaram <rajaram_k_at_netzero.net>
Date: Fri, 11 May 2001 15:27:56 -0700
Message-ID: <F001.00301A99.20010511153717@fatcity.com>

When you are doing a DIRECT LOAD INSERT, I know of a way to disable logging. First what is a Direct LOad Insert,
An Insert stmt is said to be a Direct-Load insert when the INSERT INTO SELECT command is used. This option is not available when INSERT INTO VALUES command is used.

So, to disable logging during a Direct load insert, do the following: INSERT /*+APPEND */ INTO scott.emp
NOLOGGING
SELECT * FROM scott.old_emp;

The Append Hint above makes the insert a Direct load insert.
You can use no logging with direct load insert.

U can also Use ALTER TABLE <tblname> NOLOGGING But, even then, you have to use DIRECT LOADING for nologging to take effect.

If anyone knows ways to disable logging

Correct me if I am wrong.

Rajaram.

-----Original Message-----
From: Vikas Kawatra [SMTP:VKawatra_at_innoventry.com] Sent: Friday, May 11, 2001 6:40 PM

To:     Multiple recipients of list ORACLE-L
Subject:        Turning off redo logging

If I use NOLOGGING as part of a CREATE TABLE or INDEX - it means that I don't want the creation of these objects logged.

However , say I want to turn off the logging for conventional Inserts - through transactions - how can I do that ?

vikas
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Vikas Kawatra
INET: VKawatra_at_innoventry.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).

NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rajaram
INET: rajaram_k_at_netzero.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------