Have you checked on 'connection qualifiers' in
the manual as I suggested in my reply ?
DB1 is the database name and database link name -
but I have used HR and SHIP as the connection qualifiers
to identify two separate paths to the same database.
Note the appearance of two '@' signs when using
HTH
David Lord
> -Original Message-
> From: Yechiel Adar [mailto:[EMAIL PROTECTED]]
> Sent: 08 January 2003 13:19
> To: Multiple recipients of list ORACLE-L
> Subject: Re: How to create two db-links within one schema when
> global_name
>
>
> David
> The prob
David
The problem is that HR and SHIPPING are the same database.
I wrote to him offline saying that he needs to create a user that have
access to both schemas and use one dblink only.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sen
Helmut
Try this
create public database link DB1@hr connect to hr identified by pwd_hr
using 'DB1';
create public database link DB1@shipping (???) connect to shipping
identified by pwd_shipping using 'DB1';
You should then be able to use them as follows -
select * from global_name@db1@hr;