470,636 Members | 1,526 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,636 developers. It's quick & easy.

direct path insert

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
Jul 19 '05 #1
2 7068
create table t2 NOLOGGING as select * from t1;

Pratap
Jul 19 '05 #2
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.
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Mike | last post: by
2 posts views Thread by Ben Finney | last post: by
1 post views Thread by mhearne808[insert-at-sign-here]gmail[insert-dot-he | last post: by
8 posts views Thread by eliben | last post: by
2 posts views Thread by Vissu | last post: by
7 posts views Thread by Daniel | last post: by
1 post views Thread by Chase Kang #52 | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.