frank.van.bortel_at_gmail.com wrote:
> On 28 feb, 10:51, Jerome Vitalis <vitalismanN0S..._at_gmail.com.invalid>
> wrote:
>> sybrandb wrote:
>>> On Feb 28, 9:21 am, "astalavista" <nob..._at_nowhere.com> wrote:
>>>> Hi,
>>>> I have to insert a big table into another (9.2.0.4 ):
>>>> insert /*+ append */ into T1 select * from from T2 nologging;
>>>> I have 2 questions:
>>>> - if T1 is empty, is /*+ append */ of any interest ?
>>>> - if the database is NOT in ARCHIVELOG, is nologging of any interest ?
>> ...
>>> 2 Apart from being utterly undesirable, NOARCHIVELOG does NOT stop the
>>> logging mechanism, it just means the oldest online redolog is
>>> overwritten when you run out of online logs.
>> But in NOARCHIVELOG mode, using the append hint does prevent redo
>> generation, even if the table is in LOGGING mode.
>
> 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.
Received on Wed Feb 28 2007 - 06:09:23 CST
