Forum Stats

  • 3,769,633 Users
  • 2,252,995 Discussions
  • 7,875,129 Comments

Discussions

Exporting DDL has not generated objects like triggers, sequence, procedures, etc.

I am using Oracle SQL Developer Version 21.2.0.187.


While I was trying to generate a DDL file from a relational sub-view model, the option to check triggers, sequences, etc. is missing. In the Physical Model I am using Oracle Database 12c.


Any solution will be greatly appreciated.

Tagged:

Best Answer

  • user1985769
    user1985769 Member Posts: 9 Blue Ribbon
    Accepted Answer

    I have found the solution. The relational model should have the RDMS type compatible with the physical model. Only then, the objects like Sequence, Triggers, Procedures, etc appear with the checkbox options for the DDL export.

Answers

  • user1985769
    user1985769 Member Posts: 9 Blue Ribbon
    Accepted Answer

    I have found the solution. The relational model should have the RDMS type compatible with the physical model. Only then, the objects like Sequence, Triggers, Procedures, etc appear with the checkbox options for the DDL export.