Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Is there an ER diagram tool with Oracle like the one in SQL server enterprise manager under "Diagrams"

Posted on 2007-11-19
4
Medium Priority
?
3,007 Views
Last Modified: 2008-02-01
I just inherited an Oracle database, and I would like to create a diagram with all the tables and relationships. In SQL server, I just click on the database, then R-click "diagrams" then "create new diagram". With this tool I am able to select tables, then SQL server shows me the relationships on the selected tables.

Does Oracle 10g have a tool like this?
0
Comment
Question by:sqlagent007
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 18

Accepted Solution

by:
Jinesh Kamdar earned 2000 total points
ID: 20312770
You can do this in TOAD : Tools >> ER-Diagram.
0
 
LVL 18

Expert Comment

by:Jinesh Kamdar
ID: 20312949
You could even explore another useful utility : Database >> SQL Modeler.
0
 
LVL 1

Author Comment

by:sqlagent007
ID: 20314829
Both of these features on only available in the commercial version...is there a free tool? or one that comes with Oracle?
0
 
LVL 18

Expert Comment

by:Jinesh Kamdar
ID: 20318927
There is a tool called PL/SQL developer that comes from Oracle, but i m not sure if it has any utlity to create E-R diagrams. You could get hold of Visio though which has a similar feature.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question