From JTESTA@longaberger.com Thu, 06 Sep 2001 12:25:38 -0700 From: "JOE TESTA" Date: Thu, 06 Sep 2001 12:25:38 -0700 Subject: Re: question about nologging Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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>>> g_u_r_e_v_i_c_h@yahoo.com 09/06/01 04:10PM >>>Hi,I'm running the following command:insert into owner1.table1 nologging (select * fromowner2.table2);There is no indices or constraints on tableowner1.table1, yet oracle is generating redo logs forthis transaction. Does anyone know why?thanks=====__________________________________________________Do You Yahoo!?Get email alerts & NEW webcam video instant messaging with Yahoo! Messengerhttp://im.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Gene Gurevich  INET: g_u_r_e_v_i_c_h@yahoo.comFat 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@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).