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
> > >
> >
>
> > > 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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos -- now, 100 FREE prints!
> http://photos.yahoo.com
> --
> Author: Eric Fang
> INET: eric_fang_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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
Received on Wed Jun 07 2000 - 12:34:36 CDT