As long as you are doing INSERT INTO ... using CTAS it can make use of NOLOGGING according to Oracle. I do not know why the single table does not use it. Perhaps posting relevant portion of insert stmt may provide some help The following operations can make use of NOLOGGING mode: - direct load SQL*Loader - direct-load INSERT - CREATE TABLE ... AS SELECT (CTAS) - 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 non-internal LOBs in NOCACHE NOLOGGING
Gurelei <gurelei@yahoo To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> .com> cc: Sent by: Subject: Re: insert nologging parallel/noparallel and archiving [EMAIL PROTECTED] om 08/14/2002 10:03 AM Please respond to ORACLE-L Jack, I have another twist on this situation. Again I'm loading the tables in nologging mode with all the indices dropped. Both transactions are insert into table nologging (select *). The only difference is that one select is a select from a single table while the other - is a select from two joined tables. The first insert (from a single) table produce archives, while the other (from two tables) - doesn't. Is there en explanation for that? thanks Gene --- Jack Silvey <[EMAIL PROTECTED]> wrote: > sorry, meant insert as select, not insert as append > --- Jack Silvey <[EMAIL PROTECTED]> wrote: > > Gene, > > > > This sounds right. > > > > Standard insert as append does freelist block > > checking > > and generates redo. Parallel DML generates > minimial > > redo, just for the new temp segments being > created, > > not for the datablock updates. This is one reason > it > > is so fast. > > > > Index changes are always logged, even in PDML and > > append modes. > > __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: 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).