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