Hello guys,
I need to export the DDL (tables, funcitons views) of some schemas (with cross references) to load them in a pipeline like DevOps ready.
Problem: export/backup doesn't care about the appropriate sequence of objet because these stuff will be solved by import phase.
So there is a way to automatically generate DDL in the right order?
I mean, if function Foo reference in input/output definition (also i declare section?) to table Bar, I've need to create the table before the function.
And if Bar uses function Lir (in trigger? check? else?), Lir must be create before Bar.