Oracle跨库查询表数据

工作中,经常需要用到跨库查询表数据,通过创建数据库连接方式实现

create database link 别名,连接时需要用
    connect to 用户名 identified by 密码
    using '(DESCRIPTION =                       
        (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 域名)(PORT = 端口号))
        )
        (CONNECT_DATA =
            (SERVICE_NAME = 数据库实例名称)
        )
    )';

举例如下

create database link GB
    connect to PMLF_TCMA_GD identified by PMLF_TCMA_GD
    using '(DESCRIPTION =                       
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.168.1.241)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = orcl)
        )
    )';

查询时,这样:

SELECT * FROM CUST_HIS_MENERGY@GB