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

create table t2 NOLOGGING as select * from t1;

Pratap

pratap_fin (AT) rediffmail (DOT) com (Pratap) wrote in message news:<830861d2.0408182007.69b7629d (AT) posting (DOT) google.com>...
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.