direct path insert

[Vissu]

Hi,

I am trying to move bulk of data from one table to another (all in the
db). Can I use direct insert method for doing this ?. I want to
reduce my resource consumption (undo tablespaces, etc). Any advice is
appreciated
Thanks

Vissu

[Pratap]

create table t2 NOLOGGING as select * from t1;

Pratap

[Wario]

pr********@rediffmail.com (Pratap) wrote in message news:<83**************************@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.