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

From: Lord, David - CSG <david.lord_at_hays.com>
Date: Wed, 08 Jan 2003 04:43:41 -0800
Message-ID: <F001.00529BCE.20030108044341@fatcity.com>

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). Received on Wed Jan 08 2003 - 06:43:41 CST