-- 查询所有的dblink
select * from ALL_DB_LINKS;
-- 创建dblink (数据库a为122.16.16.139,在数据库b中使用此语句;则可以在数据库b中直接查询数据库a中的表)
create database link CustPdb connect to CustCheckPdb identified by CustCheck2019 USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =122.16.16.139)(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME = CUSTPDB)))'
create database link sz_check(名字) connect to sz_check(用户名) identified by sz_check10010(密码) USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =122.16.16.103)(PORT = 1526)))
(CONNECT_DATA =(SERVICE_NAME = resource)))'
-- 在其他表中使用已经创建的dblink
select * from user@CustPdb