方法一
create database link RT_DATA
connect to DRGVIEW identified by dhcc
using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME =ORACLE)))';
方法二
CREATE DATABASE LINK DBLINK_NAME
CONNECT TO USERNAME IDENTIFIED BY PASSWORD
USING ‘TNS_NAME’