Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Reverse engineering existing remote Oracle 9i DB?

Re: Reverse engineering existing remote Oracle 9i DB?

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Thu, 23 Jan 2003 23:37:14 GMT
Message-ID: <K0%X9.779$Rj1.43969590@newssvr15.news.prodigy.com>


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:

  1. Install Oracle Client sofware
  2. Use Net Assistant (from your Start Menu) to setup tnsnames.ora
  3. Run sqlplus (from your Start Menu) and supply:
  4. Oracle userid
  5. Oracle password
  6. Alias for your Sun box that you setup in tnsnames.ora

> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US