Re: Designer 6 Question

"Van A. Messner" wrote:

> I'm just starting to learn Designer. Designer is running on a client
> machine. I set up a user (DEV60) and a repository in a database named ORCL
> on a server. I wanted to reverse engineer a twenty-table schema from a
> second database (INDI), also on a server. Connected to ORCL I tried to
> reverse engineer the tables in INDI but Designer balked at the connection to
> INDI. I was able to reverse engineer the tables from SQL scripts without
> any problem.
>
> What is normally done? Is there a repository and repository user in each
> database? Or is there a repository and repository user(s) in a separate
> database which holds the Designer information for the separate databases.
> In the latter case, how does Oracle handle the simultaneous connections to
> the database being accessed and the repository database?
>
> Thanks,
>
> Van

Van,

it all kinda' depends on what you entered in the options offered by Designer, but it may very well be possible the Designer repository tries to connect to INDI; this is a server-to-server connect... Hence tnsnames on the *server* needs to be adapted to have the INDI entry as well. V1 always used this scenario, V2+ may also use a client connect, when you fill in the user, passwd and connect string. Told u so, it kinda' depends.

HTH,
--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle Received on Tue Jan 18 2000 - 16:56:02 CST