oracle database link 连接其他oracle数据库

[color=violet][size=x-large][b]oracle database link连接其他oracle数据库方法[/b][/size][/color]
创建database link代码

create database link 名字 connect
to 用户名 identified by 密码 using
'(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IP )(PORT = 端口 ))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ora9i)
    )
)'

使用方法

select * from t_chr_inspectiondata@AAAA.US.ORACLE.COM;