Re: Reverse Engineering Oracle 8 / Solaris

Well the user_table / dba_tables has all the info, but the most = important is the table to table relational information. Oracle Designer, I'll have to take a look at it. It ships separatly from = the standard package I assume.

Thanks a lot for the tips!

/Jerra

Karsten Schwarz <karsten.schwarz_at_secco.de> wrote in message = news:38A7C945.5C304528_at_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 - 05:59:01 CST