创建ORACLE DB LINK
-- 如果创建全局 dblink,必须使用 systm 或 sys 用户,在 database 前加 public。
create /* public */ database link linkName
connect to dbLoginId identified by dbLoginPassword
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.150)(PORT = 1523))
)
(CONNECT_DATA = (SID = gg150)(SERVER = DEDICATED))
)';

浙公网安备 33010602011771号