Re: Insert append nologging

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 ?
>
> Thanks for your help

1 It doesn't matter whether a table is empty or not: insert doesn't behave differently
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.

Reading the Concepts Manual is strongly recommended, asking questions here is not a replacement.

--
Sybrand Bakker
Senior Oracle DBA