Re: Change index from nologging to logging
- From: Kumar Madduri <ksmadduri@xxxxxxxxx>
- To: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- Date: Sun, 22 Mar 2009 05:15:24 -0700
It matters because those indexes become unusable after clone.
On Sun, Mar 22, 2009 at 3:20 AM, Hemant K Chitale
<hkchital@xxxxxxxxxxxxxx>wrote:
>
> 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
>>
>
>
>
>
>
>
>
Other related posts:
