How to generate ER diagram using Oracle SQL developer

Tool Used : SQL Developer version 3.1.07
Schema Used : HR
Tables Used : Countries, Departments, Employees, Job_History, Jobs, Locations, Regions

Navigate the below path and step by step screen shots:
File > Data Modeler > Import > Data Dictionary
1# Select DB Connection and click on next

2# Select Schema/DB you wish to import and select Import to New Relational Model and click on next  

3# select the objects you wish to import and click on next and finish

4# E-R relationship diagram is created between list of tables

5# You can save and print ER relationship by following below path

File > Data Modeler > Print Diagram or Print

I hope I made my self clear. Please let me know your success and failures.

7 thoughts on “How to generate ER diagram using Oracle SQL developer”

  1. Thanks DUDE……… It is very useful to me.. I had a struck like anything… But becze of ur post I found the solution…….

    Reply
  2. I use Oracle SQL Developer Version 3.2.20.10.
    But I couldn't found the Data Modeler Menu.
    How come?
    Please give me an advice.

    Reply
  3. I followed these steps with a DB containing 800+ tables, and there are no visible connections/lines drawn between the tables.. What am I doing wrong?

    Reply

Leave a Comment