ddl generate

[baloo]

if I make ddl from serveral tables (for example references to package body ) , ddl for foreign key is generated table by table. This is not happen, if i want run this ddl. Beter is generate foreign keys at end ddl.

 

[Marco Kalter]

If all is well the tables are sorted by dependency. Is this not the case?

 

[baloo]

no, in this case (table referenced to package body) are sorted alphabetically. Generally, tables in browser are sorted abphabetically. using grag&drop into sql window ddl are generated in alpabetical order, with foreign keys, table by table. can you help me, pls?

 

[Marco Kalter]

You would have to use the Tools > Export User Objects function.

In the mean time we'll check out why the DDL option from the Object Browser does not sort by dependency.

 

[baloo]

Hi Marco,
exists two problems:
1, function Export User Object can export only object from current schema. I need export objects from various schemas.
2, drag&drop into sql window is more user friendly