1.配置本地数据库服务器的tnsnames.ora文件
编辑如下文件:如下为我的地址
D:\apps\..\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
末尾添加
MEDIADBLINK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = WANGSHUNXI.jiuqi.com.cn)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl.jiuqi.com.cn)
)
)
2.登录到本地数据库,创建database link,这里需要使用sysbase的角色登录,
执行如下语句:
create database link MEDIADB connect to zcgl identified by zcgl using 'MEDIADBLINK';
查询是否成功:
select owner,object_name from dba_objects where object_type='DATABASE LINK';
删除database link:
drop database link MEDIADB;
3.使用链接的数据库
select * from table_name@MEDIADB ;