create database link linkname
connect to user
identified by usrpwd
using 'demona';//demona为用net8 easy config创建的连接字符串
connect to user
identified by usrpwd
using 'demona';//demona为用net8 easy config创建的连接字符串
调试欢乐多
用SQL*PLUS
照楼上的做就可以
CREATE DATABASE LINK Sorcl.SA1 CONNECT TO userName IDENTIFIED BY password USING '(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = A1)(PORT = 1521)))(CONNECT_DATA = (SID = orcl)(SERVER = DEDICATED)))';