ORACLE数据库增加dblink
create public database link 名称
connect to 用户名 identified by 密码
www.2cto.com
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SID)
)
&nbsoracle账号p; )';
11g 区分大小写 账号 密码 加双引号.