Re: logging/nologging clarification

From: Tom Best <oracle_person_at_yahoo.com>
Date: Thu, 18 Jul 2002 12:42:37 -0400
Message-ID: <ah6nec$83u$1@news.bentley.com>

Chuck:

NOLOGGING prevents logging on the CTAS (of course) and also on subsequent direct path inserts, and direct SQLLOADER loads. But, it does not affect other DML (updates, deletes, normal inserts).

HTH,
Tom Best

"Chuck" <chuckh_at_softhome.net> wrote in message news:ah6p4e$pqmd7$1_at_ID-85580.news.dfncis.de...
> If I create table using CTAS NOLOGGING, will subsequent changes to the
table
> be logged if the LOGGING attribute is left on NOLOGGING? Or does that only
> prevent logging on direct path loads?
>
> TIA
>
>
Received on Thu Jul 18 2002 - 11:42:37 CDT