I am running Toad for Oracle Xpert (64 bit) version 18.104.22.168
I find this functionality very use ful to generate all the objects ddl and have a build all script. This allows me to migrate my DDL to another server and also forms the basis of release management process for database objects.
However, is there a way to control the order on build all script.
e.g. I would like the tables be created and then run the required grants before I create views or else they may fail the relevant grants may not be there.
As of now I adjust the order via trial and error method to create a correct order of execution in the build all script, which is time consuming and error prone and then this has to start again once I have to update the scripts for next release.
I believe I have similar issues when I populating the data mostly for the reference tables that hold fixed/lookup data and some times they need to be executed in a particular order depending on the FK relationtionship.