SQL Statements That Can Use No-Logging Mode
The following operations can make use of no-logging
mode: direct load
(SQL*Loader) direct-load INSERT
CREATE TABLE ... AS SELECT
CREATE INDEX
ALTER TABLE ... MOVE PARTITION
ALTER TABLE ... SPLIT PARTITION
ALTER INDEX ... SPLIT PARTITION
ALTER INDEX ... REBUILD
ALTER INDEX ... REBUILD PARTITION
INSERT, UPDATE, and DELETE on
LOBs in NOCACHE NOLOGGING mode stored out of line
hth, joe
>>> RROGERS_at_galottery.org 08/21/01 01:47PM
>>>Joe,I do not have the ability to test it at my sight. Would
you test this and respond. Thanks,Oracle Performance Tuning Tips &
Techniques Page 538. Subject NOLOGGING: "It specifies whether subsequent direct
loader (SQL*LOADER) and direct-load INSERT operations against the table,
partition, or LOB storage are logged".Sounds like only under "special"
conditions the logging is not performed.Thanks,ROR
mª¿ªm>>> JTESTA_at_longaberger.com 08/21/01 12:42PM
>>>yes.i've tested it and you should
too.joe>>> ipal_at_hotmail.com 08/21/01 11:21AM
>>>Hi,I have Emp table NOLOGGING.Does it write to log files
the insert,update,delete activity on that table
?TiaAldi_________________________________________________________________Get
your FREE download of MSN Explorer at <A
href="
http://explorer.msn.com/intl.asp">
http://explorer.msn.com/intl.asp
-- Please see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com -- Author: Aldi
Barco INET: ipal_at_hotmail.com Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).--Please see the official
ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com--Author: Ron
Rogers INET: RROGERS_at_galottery.orgFat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Tue Aug 21 2001 - 13:53:34 CDT
