dblink: 注用户名和密码有特殊字符时,必须用双引号.
create database link LK_saleb246
connect to saleb identified by ***
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
)
(CONNECT_DATA =
(SID = db10g)
(SERVER = DEDICATED)
)
)';
create database link LK_oradhyx
connect to myd_fx identified by "***"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oradhyx)
(SERVER = DEDICATED)
)
)';
create database link LK_saleb246
connect to saleb identified by ***
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
)
(CONNECT_DATA =
(SID = db10g)
(SERVER = DEDICATED)
)
)';
create database link LK_oradhyx
connect to myd_fx identified by "***"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oradhyx)
(SERVER = DEDICATED)
)
)';