--SJZH4SZDIS/SJZH4SZDIS 用户名/密码
create database link to_test
connect to SJZH4SZDIS identified by SJZH4SZDIS
using '(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.18.202)(PORT = 1521))
)
(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ORCL))
) ';
DROP DATABASE LINK to_test;
select * from SJZH4SZDIS.am_asset_0900@to_test;--做一个简单的运用DBLink查询语句,还可以再后面直接添加where条件,这里可以把SJZH4SZDIS.am_asset_0900@to_test当做一张表来看,可以喝本地的表直接进行连表查询