Oracle如何实现跨服务器操作
Sql代码
create public database link test_link
connect to test
identified by "test"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192。 168。1。 101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora9i)
)
)';
create public database link 名字
connect to 用户名
identified by "密码"...全部
Sql代码
create public database link test_link
connect to test
identified by "test"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192。
168。1。
101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora9i)
)
)';
create public database link 名字
connect to 用户名
identified by "密码"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 地址)(PORT = 端口))
)
(CONNECT_DATA =
(SERVICE_NAME = SID)
)
)';
编辑特别推荐:
RMAN备份前的操作(Windows)
Oracle正则表达式中注意的问题
oracle创建自动增长列、触发。收起