Why db_link gets its db_domain extension from global_name?

From: Reza Abouk <rabouk_at_mcimail.com>
Date: 1997/01/28
Message-ID: <32ee8361.19730390@news.internetmci.com>#1/1

Hi,

        Here is the scenario:

db_domain is default ==> WORLD

SQL> select * from v$parameter where name = 'db_domain';

NUM NAME TYPE VALUE ISDEFAULT --------- --------- --------- ------ ---------  147 db_domain 2 WORLD TRUE

SQL> select * from global_name;

GLOBAL_NAME

---

PRODV2.RCH.MCI.COM global_name is ==> PRODV2.RCH.MCI.COM

Where did the global_name got the db_domain extension???

When I create a db_link the db_domain extension is attached to the db_link name; and apparently it is comming from global_name not from v$parameter

SQL> create public database link test
  2 connect to username identified by password   3 using 'connect string';

Database link created.

SQL> select db_link from dba_db_links where db_link like ('TEST%');

DB_LINK

---

TEST.RCH.MCI.COM SQL> drop public database link test;

Database link dropped.

SQL> update global_name set global_name ='PRODV2.WORLD';

1 row updated.

SQL> select * from global_name;

GLOBAL_NAME

---

PRODV2.WORLD SQL> create public database link test
  2 connect to username identified by password   3 using 'connect string';

Database link created.

SQL> select db_link from dba_db_links where db_link like ('TEST%');

DB_LINK

---

TEST.WORLD 1 row selected.

SQL> drop public database link test;

Database link dropped.

Regards,

Reza Abouk
Reza.Abouk_at_MCI.com Received on Tue Jan 28 1997 - 00:00:00 CST