This content has been marked as final. Show 4 replies
Welcome to the forums! You will get a quicker, better response by posting in the SQL and PL/SQL forum:
SQL and PL/SQL
The SQL Developer (Not for general SQL/PLSQL questions) forum is only for questions regarding the SQL Developer tool. Please mark this as answered and repost in that other forum.
What would be the best way to Commit after every 10 000 records inserted from one table to the other using the following script :
The best way is DON'T COMMIT until the work is done. Let Oracle do its job and issue a commit when it is done.
If you want to treat your INSERT and DELETE as separate transactions isse a COMMIT after the INSERT statement and another one after the DELETE.