Re: Change index from nologging to logging

 
Hi Hemant,

In the manual (SQL Reference 10g) it says:

Specify whether the creation of the
index will be logged (LOGGING) or not logged (NOLOGGING) in the redo log file.
This setting also determines whether subsequent Direct Loader (SQL*Loader) and
direct-path INSERT operations against the index are logged or not logged.
LOGGING is the default.Are you not counting direct load/insert as DML, or do 
you believe this statement is wrong?
I'd like to test it but so busy just now...

Thanks
Charlotte
 
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
>



      

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

Other related posts: