Re: Insert append nologging

From: Anurag Varma <avoracle_at_gmail.com>
Date: 28 Feb 2007 09:17:12 -0800
Message-ID: <1172683032.747219.18330@m58g2000cwm.googlegroups.com>

On Feb 28, 11:20 am, DA Morgan <damor..._at_psoug.org> wrote:
> Jerome Vitalis wrote:
> >> The point is that NOARCHIVELOG and LOGGING (or the append hint)
> >> have nothing to do with eachother.
>
> > Of course they do. The NOARCHIVELOG mode does not just prevent log
> > archiving. It also prevents log generation when the append hint is used,
> > whatever the LOGGING mode of the table.
>
> Please provide a reference to the docs. Thanks.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Here:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14223/usingpe.htm#sthref2545 <quote>
The default logging attribute is LOGGING. However, if you have put the database in NOARCHIVELOG mode, by issuing ALTER DATABASE NOARCHIVELOG, then all operations that can be done without logging will not generate logs, regardless of the specified logging attribute. </quote>

and Metalink Note:212119.1

Anurag Received on Wed Feb 28 2007 - 11:17:12 CST