Re: Option NOLOGGING for indexes

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 13 Mar 2003 23:25:56 +1000
Message-ID: <Vr_ba.2381$LT.6455@newsfeeds.bigpond.com>

"Jusung Yang" <JusungYang_at_yahoo.com> wrote in message news:130ba93a.0303122230.73360856_at_posting.google.com...
> "Nologging" clause can be confusing sometime. For indexes, I believe
> it applies only to index creation and rebuilt operations.

Hi Jusung,

You believe correctly.

For better or for worse, standard DML stuff is always logged.

I must say with Standby databases/Data Guard being so common these days (most sites I've worked at seem to implement them), the use of nologging operations becomes a little dubious.

Cheers

Richard Received on Thu Mar 13 2003 - 07:25:56 CST