The generated DDL file for one of our schemas is 100,000+ lines.
Our build team have requested the output in smaller files.
For example separate files for tables, indexes, triggers, procedures, fucntions,
package bodies, packages, etc
We can achieve some of this by generating DDL a number of times with different
options ticked. We consider this to be fairly error prone.
Could the ability to generate a number of DDL files in a single generation into
a specfiedfolder be added?
The file names could be things like tables.sql, constraints.sql, etc