-
Hi Friends,
I am trying to insert 1 million records using the following statement:
insert into tableA
select col1,col5,col3 from tableB b, tableC c
where b.col4=c.col4;
However as soon as I give the command to execute, the SQL PLUS starts hanging.
Should one take any extra steps/measures when doing large insertions?
I am running 8.0.5 on a deck alpha machine
Thanks
manjunath
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|