这个问题简单,你只要把initsid.ora文件中的global_names设定为true
# Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = true数据库必须重新启动
# Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = true数据库必须重新启动
再用服务命名sss来建立datalink
# Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = true
修改为
global_names = false数据库服务要重启
另外init.ora在目录..\oracle\admin\databasesid\pfile下
访问时sql:select * from user.tablename@databaselink