Change index from nologging to logging
- From: Kumar Madduri <ksmadduri@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Sat, 21 Mar 2009 08:47:50 -0700
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
Other related posts:
