Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: insert nologging parallel/noparallel and archiving
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_at_yahoo To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> .com> cc: Sent by: Subject: Re: insert nologging parallel/noparallel and archiving root_at_fatcity.c 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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: gurelei_at_yahoo.com 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: ListGuru_at_fatcity.com (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: Rick_Cale_at_teamhealth.com 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: ListGuru_at_fatcity.com (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).Received on Wed Aug 14 2002 - 09:33:39 CDT
![]() |
![]() |