Title: How to create two db-links within one schema when global_names=true?
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 (???)
I always keep global_names set to FALSE but I think that if you name your database
links say DB1.hr and DB1.shipping it should work.
- Original Message -
From: Daiminger, Helmut
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Wed, 08 Jan 2003 01:44:25
two db-links
within one schema when global_names=tr
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
Look up the details of 'connection qualifiers'.
create public database link DB1@HR
connect to hr identified by pwd_hr using 'DB1';
create public database link DB1@SHIP
connect to shipping identified by pwd_shipping using 'DB1';
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk