Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Reverse engineering existing remote Oracle 9i DB?
Andrew wrote:
> 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?
>
Separate product, separate cost - Oracle Designer
> 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?
>
Don't mess with the ODBC drivers unless you have to. On your PC:
> 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)?
>
See above. You can also telnet to your Sun box and run sqlplus from there.
> 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).
>
Absolutely, but this is a big subject ... and I'd have to ask a lot more
questions before providing definitive answers. You might start at
http://tahiti.oracle.com and search for 'security'.
> Thanks!
Received on Thu Jan 23 2003 - 17:37:14 CST