CREATE PUBLIC database link data_exchange_server
CONNECT TO collect IDENTIFIED BY collect
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 132.33.254.47)(PORT = 1521))
)
(CONNECT_DATA =
(SID = oratest)
(SERVER = DEDICATED)
)
)'
ORACLE创建db_link
最新推荐文章于 2024-11-16 23:54:50 发布
本文介绍如何使用Oracle SQL创建一个公共数据库链接data_exchange_server,通过指定的用户名和密码连接到远程数据库oratest。此链接用于实现两个数据库之间的数据交换。
1021

被折叠的 条评论
为什么被折叠?



