Oracle dblink创建

-- 删除dblink
DROP PUBLIC DATABASE DBLINK名称;
-- 创建dblink
CREATE PUBLIC DATABASE LINK DBLINK名称
CONNECT TO 用户名 IDENTIFIED BY 密码
USING '套接字';

-- 示例
CREATE PUBLIC DATABASE LINK SUB_TO_HQ
CONNECT TO sss IDENTIFIED BY sfpwd123
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 10.202.46.36)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = ssssit)))';