Jerome Vitalis schreef:
> Frank van Bortel wrote:
>> 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.
>
> If the LOGGING attribute of the table is enabled (which is the default),
> redo records are not generated in NOARCHIVELOG mode with the append
> hint, whereas they are in ARCHIVELOG mode.
> So I don't think we can say "that NOARCHIVELOG and LOGGING (or the
> append hint) have nothing to do with eachother".
Had to reread a couple of times, but you are correct.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Feb 28 2007 - 14:12:26 CST
