Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Nologging
Paquette :
If the table created with nologging parameter, do it still use rollback segments and generate redo?
Please advise. Thanks.
Eric Fang
--- paquette stephane <stephane_paquette_at_yahoo.com>
wrote:
> You will still used the rollback segments and
> generate
> redo.
> Which oracle manual and which page ?
>
>
> --- Eric Fang <eric_fang_at_yahoo.com> a écrit : > How
> about insert into table_a
> > select * from table_b;
> > from the oracle manu, this is the direct insert,
> it
> > will not use rollback segment anyway, but it will
> > write to redo logs if the table is created with
> > logging.
> > Am I correct? Thanks for your replies.
> >
> > Eric Fang
> >
> > --- paquette stephane
> <stephane_paquette_at_yahoo.com>
> > wrote:
> > > 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
> > > 閏rit?
> > > > 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
> > > >
> > >
> >
>