Re: Change index from nologging to logging
Why does it matter to you that some indexes have the NOLOGGING attribute set (which is the case if they are created with NOLOGGING) ?
NOLOGGING for an Index applies *only* at *CREATE* time . Redo for all subsequent DML is *always* LOGGING. 

Hemant K Chitale
http://hemantoracledba.blogspot.com

At 11:47 PM Saturday, Kumar Madduri wrote:

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. 

<snip>

Kumar







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

Other related posts: