This is in conjunction to my y'day's query. I'm trying to do an insert to a table of about 50 million ows. How do I go about it.

It was just hanging last time I did, I have allocated a large rollback segment.

Basically I need to do a

insert into table emp1 as select * from emp;

How do I et commit for every 10000 rows.

Please help.