Change index from nologging to logging

From: Kumar Madduri <>
Date: Sat, 21 Mar 2009 08:47:50 -0700
Message-ID: <>

Some indexes were build using the nologging option. This creates corruption when the instance is refreshed. Now they need to be converted to logging option. I have two options to do this.

Alter index index_name rebuild online;
alter index index_name logging;

drop index index_name
create index index_name with logging option;

I was going with the first option. Is there a difference between doing 1 and 2.
Thank you for your time


Received on Sat Mar 21 2009 - 10:47:50 CDT

Original text of this message