三个步骤
1.创建dblink的权限
2.目标数据库的GLOBAL_DBNAME
3.执行创建语句
2.操作
1)show parameter service_names;
3.操作
create database link stu connect to {用户}identified by {密码}using ’
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST ={ip})(PORT = {端口})))
(CONNECT_DATA = (SERVICE_NAME = {实例名})))’;