Yep, It took 4 hours to insert 4 million rows. Did disabled all triggers and dropped the indexes and inserted from temp table. I am using oracle 8.1.7 on Sun E 6500.