oracle export sql inserts how to commit every N rows
908634Jan 3 2012 — edited Jan 5 2012I have a table with 5,000,000 records and I want select several fields out and insert to a MYSQL database table . So I concat a SQL to insert . But there are too many records MYSQL can't import one time (The file is more than 700M). So I should commit every N rows . I want to find a good method to solve this problem .
I use PL/SQL to execute my SQL statement . I also find when I export a table using PL/SQL I can select commit every N rows . I think if I know how PL/SQL implement it I will know how to do .
Any answer is appreciative .