Re: Reverse engineering existing remote Oracle 9i DB?

We have used Oracle Designer and it is a great product that does a LOT .

But, it also cost a fair amount and unfortunately Oracle got rid of the lightweight version that was called something like Database Designer (I think).

If all you want to do is reverse engineer, VISIO does a fairly good job of reverse engineering Oracle and other databases . The "Professional Edition" might be needed for this feature and a couple of years ago cost less than $200, I think.

I can't believe I just recommended a M$ product - I must need sleep...

If anyone knows of another option, I would also like to know about it.

"Andrew" <myfam_at_surfeu.fi> wrote in message news:c5826e91.0301231428.f921bf7_at_posting.google.com...
> Hi. I am going to reverse engineer (to build graphical representation
> of tables relationships) Oracle 9i (9.2.0.1) DB and thinking about
> using Sybase Power Designer for this. My questions are:
>
> 1.Does Oracle have any tools to build this king of picture?
>
> 2.I am going to install ODBC drivers locally to access DB because
> Oracle itself resides on the remote Sun Solaris 8 machine. Will it
> work this way?
>
> 4. Is it possible to install Oracle client software (Oracle Management
> and Design tools) and access remote Solaris Machine to control oracle
> (this is vs. making ssh and using SQLPLUS)?
>
> 5. Is it possible to secure communications, in this case, between
> Oracle client (Management and Design) software and Oracle server (runs
> remotely on Sun box).
>
> Thanks!
Received on Fri Jan 24 2003 - 01:05:30 CST