Re: INSERT millions_of_rows, how to COMMIT every 10,000 rows ?

David,

1. You are using the wrong syntax. Note that the post you are referring to has append hint just after insert. You however are using it after select. its insert /*+ append */ into newtable select * from old table;

      not

       insert into newtable select /*+ append */ from oldtable;

2. The rollback used is *minimal/near zero* .. its not zero as being claimed.

Anurag Received on Mon Mar 28 2005 - 16:03:04 CST