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.
Received on Wed Feb 28 2007 - 03:51:28 CST
