Re: Designer/2000 - Reverse Engineering

The object owner is the name of the schema in which the database resides (e.g. scott). The remote username/password are the db user you want to connect as, who (obviously) needs to be able to see scott's tables. the connect string is the TNS alias ON THE Des2K REPOSITORY SERVER for the database instance containing the database you want to reverse engineer.

It's a little complicated, but once you follow it through, it makes sense. The reverse engineer package is a stored procedure in the Des2k repository, hence the need for the alias to exist on the Des2K server.

Ilya S. Itkin <iitkin_at_houston.geoquest.slb.com> wrote in article <356DB325.6B0D4D41_at_houston.geoquest.slb.com>...
> 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
>
> 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...
>
> I'd appreciate some advise.
>
Received on Fri May 29 1998 - 14:39:12 CEST