Re: DBLink Name has to be the same as SID name?

From: David Lord <dlordster_at_gmail.com>
Date: Sun, 15 Mar 2009 09:27:43 +0000
Message-Id: <2B76FE2D-934A-4CD1-A188-16B4A0B027C9_at_gmail.com>

You can also add a 'connect_descriptor' onto the end of a database link even if global_names=true:

SQL> show parameter global_names

NAME                                 TYPE        VALUE
------------------------------------ -----------  
------------------------------
global_names                         boolean     TRUE

SQL> create database link testdb_at_scott connect to scott identified by tiger using 'testdb';

Database link created.

SQL> select * from global_name_at_testdb_at_scott;

GLOBAL_NAME

---

---

TESTDB.WORLD (see http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/ sql_elements009.htm#i27761)

Regards
David Lord

On 15 Mawrth 2009, at 05:53, Yechiel Adar wrote:

> Just a small correction.
> If global_name=true the dblink name must be equal to the result of:
> select * from global_name;
> which may or may no be the SID.
> Adar Yechiel
> Rechovot, Israel
>
>
> Lyndon Tiu wrote:
>>
>> That worked. Thanks.
>>
>> On Thu, 12 Mar 2009 20:45:42 0100 Kurt-Franke_at_web.de wrote:
>>
>>> global_names is changeable with "alter session"
>>>
>>>
>>
>> --
>> Lyndon Tiu
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Mar 15 2009 - 04:27:43 CDT