aspose file tools*
The moose likes General Computing and the fly likes Oracle Database showing existing tables and their relationships . Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "Oracle Database showing existing tables and their relationships ." Watch "Oracle Database showing existing tables and their relationships ." New topic
Author

Oracle Database showing existing tables and their relationships .

Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

Hi ,

Is there a tool around that would produce a diagram showing existing tables and their relationships given a connection to a database ?

I am using Oracle as Database .


Save India From Corruption - Anna Hazare.
Ernest Friedman-Hill
author and iconoclast
Marshal

Joined: Jul 08, 2003
Posts: 24187
    
  34

TOAD is a huge player in this space. I'm personally fond of DbVisualizer.


[Jess in Action][AskingGoodQuestions]
Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

Thank you very much .
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1851
    
  16

A bit late, I know, but just in case anybody else wants to do this...

TOAD is great, but it's also very expensive.

As an alternative, you could try Oracle's free SQLDeveloper Data Modeler.

This is a pretty good data modelling tool that allows you to import an existing model from a database schema or from other tools e.g. Oracle Designer. You can then view and maintain the model easily via the diagramming tools.

It's easy to install and get started with, costs nothing, and it provides a lot of functionality for data modelling, DDL generation and so on.


No more Blub for me, thank you, Vicar.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Oracle Database showing existing tables and their relationships .