Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Oracle 8i - Database Schema Diagram

Hey,

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

Any ideas of how I go about this.....
0
MButler
Asked:
MButler
  • 2
1 Solution
 
bmoshierCommented:
YES!

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

http://www.keeptool.com/en/products.html

http://www.keeptool.com/en/download.html

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

http://www.bmoshier.net/bertram
0
 
MButlerAuthor Commented:
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....
0
 
bmoshierCommented:
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

http://www.bmoshier.net/bertram
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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