Re: How to create two db-links within one schema when global_name

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 <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 08, 2003 2:43 PM

> Helmut
>
> Try this
>
> create public database link DB1_at_hr connect to hr identified by pwd_hr
> using 'DB1';
> create public database link DB1_at_shipping (???) connect to shipping
> identified by pwd_shipping using 'DB1';
>
> You should then be able to use them as follows -
>
> select * from global_name_at_db1@hr;
> select * from global_name_at_db1@shipping;
>
> Regards
> David Lord
>
> -----Original Message-----
> Sent: 08 January 2003 09:44
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!
> Is there a way to create two db-links within one schema when
> global_names=true?
> e.g.
> create public database link DB1 connect to hr identified by pwd_hr using
> 'DB1';
> create public database link DB1 (???) connect to shipping identified by
> pwd_shipping using 'DB1';
> This is 8.1.7 on Solaris.
> Thanks,
> Helmut
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Lord, David - CSG
> INET: david.lord_at_hays.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).