How to add commits every 500 rows for Insert Statements in Export Dataset
説明
Insert statement export file is 50 MB in size and only has one commit at the end. It consumes a log of rollback space and takes 45 minutes to run. Adding a commit every 500 records would speed this up considerably. Is there an option to 'add commit after 'x' rows' for the insert statement output?
対策
WORKAROUND
none
STATUS
An enhancement request has been submitted to the Toad Idea Pond for consideration in a future release of Toad for Oracle. Click here to vote or comment on the change request.
