error while connecting using DB link

[sadha@dbsupport]

SQL> create public database link DEV.TFAP01.WORLD
2 connect to ops$tf01 identified by ops
3 using '(DESCRIPTION =
4 (ADDRESS_LIST =
5 (ADDRESS =
6 (COMMUNITY = TCPIP.world)
7 (PROTOCOL = TCP)
8 (Host = 10.171.44.14)
9 (Port = 1521)
10 )
11 )
12 (CONNECT_DATA =
13 (SID = TFAP01)
14 (GLOBAL_NAME = false)
15 )
16 )';

Database link created

SQL> select distinct brch_code from dbt_m_branch@DEV.TFAP01.WORLD;

select distinct brch_code from dbt_m_branch@DEV.TFAP01.WORLD

ORA-02085: database link DEV.TFAP01.WORLD connects to TFAP01.US.DB.COM


1.when i execute the above query it connects to TFAP01.US.DB.COM
instead of DEV.TFAP01.WORLD.
2.The db link TFAP01.US.DB.COM does not exist in the database.

pls help

[paragp1981]

create statement for "DEV.TFAP01.WORLD" shows it should connect to
TFAP01 as per connect string you have given. "(SID = TFAP01)"

Which SID you intend to connect to via "DEV.TFAP01.WORLD"

[sadha@dbsupport]

Yes i want to make use of the SID TFAP01 only

[davey23uk]

do you have global_names set to true in the database

[sadha@dbsupport]

im not aware if the global_name is set to true
but i dropped the dblink and recreated with global_name=true.

[paragp1981]

and now does it work ?

[PAVB]

im not aware if the global_name is set to true

That's the kind of answer I would never accept from any of my guys, go and check global_names parameter!
Either you are dead lazy or you are clue less ... actually I would prefer the second, there is no cure for the first.