• VMware

    Learn about VMware virtualization for its products like vsphere ESX and ESXi, vCenter Server, VMware View, VMware P2V and many more

  • Linux

    Step by step configuration tutorials for many of the Linux services like DNS, DHCP, FTP, Samba4 etc including many tips and tricks in Red Hat Linux.

  • Database

    Learn installation and configuration of databases like Oracle, My SQL, Postgresql, etc including many other related tutorials in Linux.

    • Home / database / How To / Oracle / SQL / How to generate ER diagram using Oracle SQL developer

    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.

    How to generate ER diagram using Oracle SQL developer How to generate ER diagram using Oracle SQL developer Reviewed by Tarun Tripathi on Wednesday, March 19, 2014 Rating: 5

    7 comments:

    1. Kandhamaran Chandrasekar20 May 2014, 10:09:00

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

      ReplyDelete
      Replies
      1. tarunendra20 May 2014, 21:03:00

        Thanks for your feedback, I am glad it was helpful.


        Regards,
        Tarun

        Delete
    2. Hendi Santika's Blog5 Aug 2015, 15:08:00

      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.

      ReplyDelete
    3. Zaidi18 Sep 2015, 12:10:00

      Great Dude,It really helpfull

      ReplyDelete
    4. MD H Rahman14 Dec 2015, 16:35:00

      Thanks mate!

      ReplyDelete
    5. Vijayakumar Krishnan8 Feb 2016, 06:46:00

      Thanks Friend for sharing this tips with us all...It really helped to me!!!

      ReplyDelete
    6. Jack McGuire26 May 2017, 02:37:00

      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?

      ReplyDelete

    Subscribe to: Post Comments ( Atom )
    Powered by Blogger.