oracle数据库链

oracle数据库链

creare database link 数据库链名

connect to 用户名 identified by 密码

using

'

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 要连接的地址(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

数据路径（\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora）

'

select * from 表名@数据库链名；

======================================================================

--数据库链

create database link link_java --定义数据路链

connect to java05 identified by java05

using

'

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.106)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

'

select * from bank@LINK_JAVA;