本文介绍了一个具体的数据库链接创建和删除示例，包括drop database link 和 create database link 的SQL语句，展示了如何设置连接字符串、指定远程数据库地址及端口等关键步骤。
drop database link testdb_DBLINK
/
create database link testdb_DBLINK connect to user identified by password USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.192.10)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = test_db)
)
)'
/
/
create database link testdb_DBLINK connect to user identified by password USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.192.10)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = test_db)
)
)'
/
扫一扫
1519
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
