DROP TABLE ex_1;
-- 创建外部表
create external table ex_1(c1 int,c2 int,c3 int) from 'D:\dmdbms\data\external_table\ex_1.ctl';
-- 查询外部表
select * from ex_1;
端口:5239
-- 创建外部链接
create public link "LINK1" connect 'DAMENG' with "SYSDBA" identified by "******" using '192.168.118.194/5236';
-- 根据外部链接查询外部表
select * from ex_1@LINK1;
-- 创建外部表的同义词
create OR REPLACE SYNONYM ex_synonym FOR ex_1@LINK1;
-- 根据同义词查询数据
select * from ex_synonym;
支持
端口:5236
端口:5239