Re: Insert append nologging

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 28 Feb 2007 19:41:51 +0100
Message-ID: <es4ib6$rej$1@news5.zwoll1.ov.home.nl>

Jerome Vitalis schreef:
> DA Morgan 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.

>
> Not sure this is officially documented.
> Have a look at Tom's explanation though: http://tinyurl.com/ywjsae
> (Tom's first answer.)

All I see is the append hint being the crucial thing. Use the append hint: no redo.
No append hint: redo generated, whether you are in archivelog or in noarchivelog mode!

Also, see my reply to Anurag Varma

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Wed Feb 28 2007 - 12:41:51 CST