Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Update a table with no logging?

Re: Update a table with no logging?

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 15 May 2001 20:07:11 +1000
Message-ID: <3b00ffd9$1@news.iprimus.com.au>

"Alan" <a_at_a> wrote in message
news:989872743.27642.0.nnrp-01.9e985e86_at_news.demon.co.uk...
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> > As said by Howard Rogers
> today in this group: nologging applies only to
> > *very specific* types of DML.
> > Your suggestion is not going to work.
> > If he is on 8i, he should be able to use the /*+APPEND*/ hint, which
 will
> > add the data in *direct* mode (so indexes need to be rebuild).
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
>
> Can you clarify what you mean by "so indexes need to be rebuild". Doesn't
> Oracle update the indexs automatically, in the same way that it does for
 an
> sql*loader direct path load.
>
>
Received on Tue May 15 2001 - 05:07:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US