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.