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;

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;