Sunday, June 16, 2013

How to export data model to DDL with Oracle SQL Developer Data Modeler

This post will show post-action after the relational data model has been created.
The main purpose is to export the relational model as DDL, and this DDL is runnable SQL script to generate the database schema.
Besides that, it could help us to validate the correctness of data model during DDL generation.


1. make sure relational data model has been created.

2. Open the DDL File Editor
    File > Export > DDL File

3. Click Generate 

4. Review DDL Generation Options: Tree View, Tables, PK and UK Constraints, Indexes, Foreign Keys, Views

5. Click OK

6. If errors alert, search for "-- Error --" and fix it.

7. Once fixed, repeat step 2-5 again.



  1. There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.

    Oracle Training Chennai
    Oracle Training Center in Chennai

  2. It incorporates strong information security layers that ensure your delicate data.Change Site URL Using MySQL



Related Posts Plugin for WordPress, Blogger...