Is there anyway to skip the creation of the ‘Build All’ script at the end of the Generate Schema Script function?
Using Toad for Oracle versions 12.12 or 13.0, select Database, then Export and then Generate Schema Script. From there I select a set of schema’s to export, check the Create Individual Object DDL files option, pick a high level directory and click the run button. The part where it generates the individual objects seems to work great, no issues but Toad will usually choke and die on the when it gets to the Generate Schema Build Script. Turning off the sort option helps but I still get crashes on schemas with a lot of objects.
Version 13.0 is better at this, it seems to handle very large schema’s better and the interface is easier to use, but it still crashes at the Generate Schema Build Script step for schemas with hundreds or thousands of objects.
Thanks in advance to anyone that can help.