Re: Nologging

right out of oracle docs, 8.1.5 on create table statement:

In NOLOGGING mode, data is modified with minimal logging (to mark new extents INVALID and to record dictionary changes). When applied during media recovery, the extent invalidation records mark a range of blocks as logically corrupt, because the redo data is not fully logged. Therefore, if you cannot afford to lose this table, you should take a backup after the NOLOGGING operation.

Joe
Eric Fang wrote:
>
> If I create a table with nologging parameter, what
> happen if later on I insert into the table with
> insert into foo select * from bar where blahblah,
> or insert into foo values ( ... ).
>
> Does the above inserts has the logging or not?
> Say, the application is executing those insert
> statements, then the system crashes, then what
> happened to all those insert?
>
> Thanks in advance.
>
> Eric Fang
>

-- 
Joe Testa  http://www.oracle-dba.com
Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs