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_at_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! Messenger
http://im.yahoo.com--
Please see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com-- Author: Gene
Gurevich INET: g_u_r_e_v_i_c_h_at_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_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 Thu Sep 06 2001 - 14:25:38 CDT
