Re: direct path insert

pratap_fin_at_rediffmail.com (Pratap) wrote in message news:<830861d2.0408182007.69b7629d_at_posting.google.com>...
> create table t2 NOLOGGING as select * from t1;
>
> Pratap

Try

insert into /*+ append */ table2

    select * from table1;

commit;

If a table or an index is specified with nologging, this hint applied with an insert statement produces a direct path insert which reduces generation of redo. Received on Thu Aug 26 2004 - 15:43:21 CEST