Re: Change index from nologging to logging
- From: Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 23 Mar 2009 14:02:21 -0700 (PDT)
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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
