Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to create two db-links within one schema when global_name
Yechiel
There is a well hidden feature that allows you to put an extra 'connect_descriptor' on the end of a database link name for exactly this purpose. Take a look at
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elem ents10a.htm#27762
for a description.
HTH
David Lord
> -----Original Message-----
> From: Yechiel Adar [mailto:adar76_at_inter.net.il]
> 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 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).
>
A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
-- 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 - 08:48:51 CST
![]() |
![]() |