I have just created a dblink between an 8i and 9i db. However, I have become slightly confused regarding domains...
Db1
Select * from global_name;
_________________________________
DB1.local
db2
select * from global_name;
_________________________________
db2
I have set global_names = false on both databases but to get the db link working i had to reference db1 as db1.world...
-------------------------------------------------------------------
create database link db1.world connect to user1 identified by pass1 using 'DB1';
-------------------------------------------------------------------
why is this? I always thought turning the global_names=false meant you didn't have to do this...?
Thanks in advance
Kev