Re: Change index from nologging to logging

From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Sun, 22 Mar 2009 05:15:24 -0700
Message-ID: <a2b1e7610903220515n11869e5aydf90dfd7dee8fc0b_at_mail.gmail.com>



It matters because those indexes become unusable after clone.

On Sun, Mar 22, 2009 at 3:20 AM, Hemant K Chitale <hkchital_at_singnet.com.sg>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
>>
>
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Mar 22 2009 - 07:15:24 CDT

Original text of this message