Re: table nologging in 8i

Please correct me if I misinterpreting this excerpt from Oracle Concepts, 8i:

"SQL Statements That Can Use No-Logging Mode

Although you can set the NOLOGGING attribute for a table, partition, index, or tablespace, no-logging mode does not apply to every operation performed on the
schema object for which you set the NOLOGGING attribute. Only 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

All of these SQL statements can be parallelized. They can execute in logging or no-logging mode for both serial and parallel execution.

Other SQL statements are unaffected by the NOLOGGING attribute of the schema object. For example, the following SQL statements are unaffected by
NOLOGGING mode: UPDATE and DELETE (except on some LOBs, as noted above), conventional path INSERT, and various DDL statements not listed above. "

Regards
Karen

Steve Haynes wrote:

> I quote tom kyte:
>
> Nologging only affects very very specific operations. For
> exmaple, from the alter index syntax statement in the SQL
> reference
Received on Mon Aug 07 2000 - 00:00:00 CDT