Re: question about nologging

[JOE TESTA]

standard answer for redo(dont think yours is covered):   . 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 >>> [EMAIL PROTECTED] 09/06/01 04:10PM >>> Hi, I'm running the following command: insert into owner1.table1 nologging (select * from owner2.table2); There is no indices or constraints on table owner1.table1, yet oracle is generating redo logs for this transaction. Does anyone know why? thanks ===== __________________________________________________ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich   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).