Oracle如何实现跨数据库查询

时间：2019-09-16 11:24:31 收藏：0 阅读：165

Oracle如何实现跨数据库查询

https://blog.csdn.net/Jerry_an/article/details/87873923

create public database link "dbtrue"

connect to "ztzs_erp2" identified by "密码"

using ‘(DESCRIPTION =

(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.13*)(PORT = 1521))
)

(CONNECT_DATA =
(SERVICE_NAME = "oradb")
)
)‘;

select * from "Project"@dbtrue.ztzs;

MSSql 实现跨库查询：

EXEC sp_addlinkedserver @server = N‘oldErpTrue‘, @srvproduct=N‘ZSErp‘,@provider=N‘SQLOLEDB‘, @datasrc=N‘172.16.10.100‘

EXEC sp_addlinkedsrvlogin @rmtsrvname = N‘oldErpTrue‘, @locallogin = NULL ,@useself = N‘False‘, @rmtuser = N‘sqluser‘, @rmtpassword = N‘qwe_123456*‘

select * from oldErpTrue.ZSErp.Material.Material;

原文：https://www.cnblogs.com/hwubin5/p/11525760.html