Oracle 8i - Database Schema Diagram

Posted on 2003-02-19
Medium Priority
Last Modified: 2013-12-12

I need to generate a schema diagram of all tables and relationships for an Oracle database.

Any ideas of how I go about this.....
Question by:MButler
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
  • 2

Accepted Solution

bmoshier earned 150 total points
ID: 7982753

I use Keep Tool 5 to do the ER-Diagrammer to generate the ERD for a schema.  Works great.  The URLs are:



It works on Windows XP, Windows 2000, Windows NT 4.0, Windows 95/98 but against any Oracle database regardless of hardware/operating system.

You can download and then test Hora, the ER-Diagrammer, and the PL/SQL-Debugger for 30 days free of charge. The software provides all the functions of the registered version. After 30 days of testing, you must either purchase a license or delete the software completely from your computer.

As for cost after the 30 days, ER-Diagrammer is $210 US for a full license.

Anything else?

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA


Author Comment

ID: 7986504
This tools seems to be sufficient, however the printing options are basic. Can you tell me how to print the schema
at full size rather than at reduced (1 page)....

the schema has 500 tabels in it :-)

BTW... you have the points....

Expert Comment

ID: 7996162
Thanks for giving me the points.  As for the printing I use the "multiple pages" drop down box.  Normally, I'll print to either:

1)  Physically (to actual paper)  It requires multiple pages, though (2x2 = 4 sheets; 10x10 = 100 sheets).  I then tape the sheets either to the wall OR to a large poster board sheet.

2)  PDF (Acrobat Distiller).  This allows for sharing (and saving).

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

764 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