oracle 创建dblink 及同义词

//创建(与统一认证产生)link
create public database link UCENTER_LINK
connect to "单点用户名" identified by "单点密码"
using '(DESCRIPTION =
(ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP)(HOST = "数据库IP")(PORT = 1521))
)
(CONNECT_DATA = 
(SERVICE_NAME = 实例名)
)
)';

//创建同义词sql(审批库3个表在统一认证中读取)
create synonym sys_user FOR sys_user@UCENTER_LINK;
create synonym sys_office FOR sys_office@UCENTER_LINK;
create synonym sys_dict FOR sys_dict@UCENTER_LINK;