Nologging only works with direct write inserts :
create as select, parallel dml and sql*loader with the
direct path option.
Normal writes are logged even with the nologging
option.
- "Joseph S. Testa" <teci_at_oracle-dba.com> a écrit :
> 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
> --
> Author: Joseph S. Testa
> INET: teci_at_oracle-dba.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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Received on Mon Jun 05 2000 - 02:09:50 CDT
