本文详细介绍了如何创建Dblink连接到特定数据库，并通过创建或替换同义词来关联相关表。
首先创建Dblink
create database link CFS_BANK
connect to name identified by PASSWORD using '
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 10.110.3.26)
(PORT = 1521)) )
(CONNECT_DATA =
(SERVICE_NAME = cfs)
) )';
-- Create the synonym
create or replace synonym V_YHDD_YHJKBANKSTATE
for CFS_BANK.YHJKBANKSTATE;
for CFS_BANK.YHJKZHB;
然后编辑对应的同义词，关联上 Dblink
create database link CFS_BANK
connect to name identified by PASSWORD using '
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 10.110.3.26)
(PORT = 1521)) )
(CONNECT_DATA =
(SERVICE_NAME = cfs)
) )';
-- Create the synonym
create or replace synonym V_YHDD_YHJKBANKSTATE
for CFS_BANK.YHJKBANKSTATE;
for CFS_BANK.YHJKZHB;
然后编辑对应的同义词，关联上 Dblink
扫一扫
437
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
