error while connecting using DB link
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