Re: Insert append nologging

From: Jerome Vitalis <vitalismanN0SP4M_at_gmail.com>
Date: Wed, 28 Feb 2007 21:28:36 +0100
Message-ID: <45e5e5ef$0$3459$a3f2974a@nnrp1.numericable.fr>

astalavista wrote:
> Hi,
>
> I have to insert a big table into another (9.2.0.4 ):
> insert /*+ append */ into T1 select * from from T2 nologging;
>

As explained in the link provided by Anurag http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:8289905224297 the "nologging" string in your insert statement does not disable LOGGING.

You have to use "alter table t1 nologging" instead. Received on Wed Feb 28 2007 - 14:28:36 CST