Change index from nologging to logging

From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Sat, 21 Mar 2009 08:47:50 -0700
Message-ID: <a2b1e7610903210847y6fa4f730qe505702356fb54ba_at_mail.gmail.com>

Hi
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;

or
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

Kumar

--
http://www.freelists.org/webpage/oracle-l

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