Re: Insert append nologging

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 01 Mar 2007 13:51:22 -0800
Message-ID: <1172785879.930600@bubbleator.drizzle.com>

Jerome Vitalis wrote:
> 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.

If my original question ... "Please provide a reference to the docs" generated this I am pleased. It certainly seems to have clarified things all around.

Again ... testing proves more valuable than text.

Thanks all.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Mar 01 2007 - 15:51:22 CST