创建脚本:
create public database link dblink connect to rtt identified by "123" using '
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.12.40)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rtt)
)
)';
其中dblink为创建的名字,rtt为远程数据库的用户名,123为远程数据库的密码,密码必须用“”括起来。