The sync script generated by the Compare Schema module in Toad for adding columns with default value causes performance issue or table lock for large table.
Submitted enhancement requests:
Idea#337 -http://toadfororacle.ideascale.com/a/dtd/Add-column-to-a-table-with-default-value-requires-improvement/108344-8477
Idea#338 -http://toadfororacle.ideascale.com/a/dtd/Adding-multiple-columns-with-default-value-need-improvement/108388-8477
Vote for these ideas to get this new feature into the product
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center