Re: Designer/2000 - Reverse Engineering

On Thu, 28 May 1998 13:55:33 -0500, "Ilya S. Itkin" <iitkin_at_houston.geoquest.slb.com> wrote:

>I am trying to reverse engineer a database:
>
>RON -> Utilities -> Reverse Engineer Database
>
>Under the Options tab I fill out all the fields but the OK button is
>grayed out.
>
>If I select the Objects tab, it says: ORA-12154: TNS could not resolve
>service name

The database where your repository is installed can not resolve this service name. You have to edit the tnsnames.ora on this server (or contact your dba to do this). The repository database is creating a link to the database you wish to reverse engineer (not your client).

>
>At the same time if I go to RON -> Tools -> SQL*Plus, I can connect
>successfully to that very remote database I am trying to reverse
>engineer.
>
>Also I do not really understand the meaning of the "Object Owner" field
>on the Reverse Engineer Database Objects/Options screen. I tried both
>(1) the designer user (which is its default when it comes up) and (2)
>the same one as in "Remote Username". Both tries don't make the OK
>button available - still grayed out...

The object owner is the database scheme you wish to reverse engineer and remote user/pwd is your database account on wich you can access this database (can be the same).

>
>I'd appreciate some advise.

Best regards

Henrik Received on Wed Jun 10 1998 - 13:11:48 CEST