Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Turning off redo logging
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;
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 --------------------------------------------------------------------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 11 2001 - 17:27:56 CDT