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;