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.

Steps:

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.


Done!!


7 comments:

  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

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

    ReplyDelete
  3. Yes i am totally agreed with this article and i just want say that this article is very nice and very informative article.I will make sure to be reading your blog more. You made a good point but I can't help but wonder, what about the other side? !!!!!!Thanks Jen Selter Instagram

    ReplyDelete
  4. Acknowledges for paper such a beneficial composition, I stumbled beside your blog besides decipher a limited announce. I want your technique of inscription. seo

    ReplyDelete

LinkWithin

Related Posts Plugin for WordPress, Blogger...