1、同一个数据库的用户(a)要用到用户(b)的表等,所需要建立的连接
CCPBS_19 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.38.19)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CCPBS)
)
)
格式:create public database link link_name connect to username(b)identified by****passwordusing ‘SID引用名’;
例子:create public database link ecbm_19 connect to ecbm_userName identified by ecbm_pwd using ‘CCPBS_19’;
2、不同数据库之间的访问
create database link test_DBLINK
connect to username identified by "password "
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
查询 select * from tablename@link_name;
如 select * from emp@ecbm_19;
删除 DROP PUBLIC DATABASE LINK ecbm_19;
--查询刚刚新建的dblink
select * from all_db_links order by created desc;
https://www.cnblogs.com/o-andy-o/category/365721.html