Re: Reverse Engineering Oracle 8 / Solaris

From: Karsten Schwarz <karsten.schwarz_at_secco.de>
Date: Mon, 14 Feb 2000 10:22:13 +0100
Message-ID: <38A7C945.5C304528@secco.de>

Hi Jerra,

of course this is possible. Oracle provides a Case tool called Oracle Designer (it is probably a little bit oversized for this task) which can handle this. On the other hand you will find all the information about the database objects in the data dictionary views (all_tables, all_objects, all_indexes, all_constraints ....)

Hope it helps
Karsten

Jerra schrieb:

> Hi,
> Is it possible to from a existing database (Oracle 8 / Solaris) create a database diagram.
> If you are familiar with Sybase Dataarchitect (MS enviroment), from that program it is possible via ODBC to reverse engineer an existing database to get a diagram it is something similar I am looking for.
> We have a big database on Solaris and need a diagram for it, to do this by analysing table by table would take to much time.
>
> Any help greatly appreciated!
>
> /Jerra
Received on Mon Feb 14 2000 - 03:22:13 CST