Re: Update a table with no logging?

From: Alan <a_at_a>
Date: Mon, 14 May 2001 22:34:38 +0100
Message-ID: <989872743.27642.0.nnrp-01.9e985e86@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 Mon May 14 2001 - 16:34:38 CDT