Create Jpg, png, PDF Oracle Database Schema ER / Table Relationship Diagram Using Data Modeler

Step 1. Open sql developer data modeler
Step 2. Navigate through File -> import -> data dictionary
Step 3. Click on Add button and provide the database connection details
Step 4. Connect to the database and click Next and the select the schema details
Step 5. Select the tables which you wanted to get the diagram and click finish.
The above steps will give you the ER diagram on the screen. From there you can easily generate the .jpeg,
.png, .pdf files using the print diagram option in the File menu.

File -> print diagram
Specify the file location where you wanted to save the file.

Now you are done with the job. 
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google