创建databaselink关联,查询关联用户表

1、创建databaselink关联

CREATE DATABASE LINK linklianjie_name
CONNECT TO oracle IDENTIFIED BY oracle123
USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=172.24.228.44)))';

 

 2、查询创建的databaselink关联

SELECT DB_LINK, OWNER, USERNAME, HOST, CREATED FROM DBA_DB_LINKS;