Currently, "Database | Import | Import Table Data" only has three commit options at the end of the Wizard.
1. Commit after each record
2. Don't commit
3. One commit after all record
Will Toad in the future have commit after nth row?
WORKAROUND:
When Import Table Data feature is slow and while an option to commit after nth row can be a solution to prevent from loosing data, if in case of a crash, it is still not the best solution. It is suggested to the SQL*LOADER to do your imports.
STATUS:
Enhancement request ST59392 has been submitted to Development for consideration in a future release of Toad for Oracle.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center