Oracle实现跨服务器操作

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)
     )
   )';

 

 

 

查询时使用 select * from table@test_link