Yes, you will use rollback segments and generate redo.
The only way not to use the rollback segments is to
used a hidden pararameter in init.ora, which is not
advised.
Nologging only works for direct path insert.
- Eric Fang <eric_fang_at_yahoo.com> a écrit : >
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
> > > > >
> > > >
> > >
> >
>
> > > > > 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
>
=== message truncated ===
Stephane Paquette
Received on Thu Jun 08 2000 - 01:43:53 CDT
