RE: Change index from nologging to logging

From: Kenneth Naim <>
Date: Sun, 22 Mar 2009 11:34:55 -0400
Message-ID: <717ED336BBAD4B30B0A9ECA5209361B5_at_KenPC>

I believe the poster is also using dataguard, and when they open the standby instance the indexes are market corrupt and need to be rebuilt.      

From: [] On Behalf Of Kumar Madduri
Sent: Sunday, March 22, 2009 8:15 AM
To: Hemant K Chitale
Subject: Re: Change index from nologging to logging  

It matters because those indexes become unusable after clone.

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

At 11:47 PM Saturday, Kumar Madduri wrote:

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.



Received on Sun Mar 22 2009 - 10:34:55 CDT

Original text of this message