create database link trps_link connect to trps identified by trps
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.119.92.103)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = trps)
)
)';
select * from t_trps_org@trps_link;
create view t_test as select * from trps.t_trps_org@trps_link;
--创建同义词
create synonym t_link_trps for trps.t_trps_org@trps_link;
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.119.92.103)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = trps)
)
)';
select * from t_trps_org@trps_link;
create view t_test as select * from trps.t_trps_org@trps_link;
--创建同义词
create synonym t_link_trps for trps.t_trps_org@trps_link;