Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insert append nologging
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.)
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". Received on Wed Feb 28 2007 - 13:59:15 CST