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;
1. The Append Hint above makes the insert a Direct load insert.
2. 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:[EMAIL PROTECTED]]
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: [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).
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: [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).
