Re: Nologging

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
  > &#38287;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
  > >
  >

  ---

  
  > > 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!?
  > Yahoo! Photos -- now, 100 FREE prints!
  > http://photos.yahoo.com
  > --
  > Author: =?iso-8859-1?q?paquette=20stephane?=
  > INET: stephane_paquette_at_yahoo.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).
  

  ---