Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3034
  • Last Modified:

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

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
sqlagent007
Asked:
sqlagent007
  • 3
1 Solution
 
Jinesh KamdarCommented:
You can do this in TOAD : Tools >> ER-Diagram.
0
 
Jinesh KamdarCommented:
You could even explore another useful utility : Database >> SQL Modeler.
0
 
sqlagent007Author Commented:
Both of these features on only available in the commercial version...is there a free tool? or one that comes with Oracle?
0
 
Jinesh KamdarCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now