Re: Nolog writes log ?

[JOE TESTA]

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 >>> [EMAIL PROTECTED] 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 >>> [EMAIL PROTECTED] 08/21/01 12:42PM >>> yes. i've tested it and you should too. joe >>> [EMAIL PROTECTED] 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 ? Tia Aldi _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco   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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers   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).