Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insert append nologging
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