Re: NOLOGGING and index

"Ales Voboril" <alesv_at_post.cz> wrote in message news:<9qjnt0$1po0$1_at_ns.felk.cvut.cz>...
> Hi again,
> I see I was a bit verbose last week, so I try to summarize it:
>
> I found that in case of direct-load INSERT, indexes on the populated
> NOLOGGING table generate significant amount of redo regardless of their
> NOLOGGING status.
>
> Could anybody confirm or disconfirm that?
>
> Thanks in advance,
> Ales

You are right. For some reason the nologging does not seem to work on the index. Maybe it is not so strange; sqlload did put them in directload status. Just drop and recreate the indexes when ready.

Ronald.