Oracle db_link跨库访问

Oracle db_link跨库访问：

https://www.cnblogs.com/Marydon20170307/p/8831134.html

create database link to_64 connect to system identified by Hao123 using '10.0.13.64:1521/orcl';

to_64        db_link 的名称

connect to system identified by Hao123 连接到远程库的用户名和密码

using '10.0.13.64:1521/orcl';           连接到远程库的IP、端号、实例名

 

select count(*) from c##nc659.BD_BOM@to_64;

c##nc659.BD_BOM@to_64    B库表名@db_link