Creating database diagram of Oracle database using Oracle SQL Developer

Introduction
In this post I will explain how to create database diagram of Oracle database using “Oracle SQL Developer”

Description
We can use Oracle SQL Developer to generate database diagram of an Oracle database. Please follow these steps to generate database diagram of an Oracle 11g Express Edition database. You can refer to this article to install Oracle Express database and Oracle SQL Developer

Step 1: Open Oracle SQL Developer

2013-12-19 23_46_03-

Step 2: Select File > Data Modeler > Import > Data Dictionary

2013-12-18 23_52_48-Oracle SQL Developer _ system-XE

Step 3: Select connection name in the Data Dictionary Import Wizard and click on Next

2013-12-18 23_56_33-Data Dictionary Import Wizard

Step 4: Select the Database/Schema and click on Next

2013-12-19 00_03_23-Data Dictionary Import Wizard

Step 5: Choose the tables for which you want to create database diagram and click Next. You can also select other database objects like Views

2013-12-19 00_06_00-Data Dictionary Import Wizard

Step 6: Click on Finish

2013-12-19 00_08_24-Data Dictionary Import Wizard

Step 7: Click on Close to close the log window

2013-12-19 00_31_36-View Log

Step 8: Now you can view the database diagram of tables with their relationship as following

2013-12-19 00_39_10-Oracle SQL Developer _ system-XE (Untitled_1)

We have a  toolbar in the top called Relational Model (View > Show Toolbars > Customize Main Toolbar > Relational Model) to view and customize the data dictionary

Step 9: Select File > Data Modeler > Print Diagram > To Image File to save this diagram as an image (.png) file. You can also select “To PDF File” or “To SVG File” as output type

2013-12-19 00_33_49-Oracle SQL Developer _ system-XE (Untitled_1)

Step 10: Finally we have database diagram of HR database as following

system-XE

One thought on “Creating database diagram of Oracle database using Oracle SQL Developer

Leave a Reply

Your email address will not be published. Required fields are marked *