Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
