首先建立远程连接
create public database link l_name connect to user identified by pw
using '连接字符串'
然后在sql中
select * from tbname@l_name;
create public database link l_name connect to user identified by pw
using '连接字符串'
然后在sql中
select * from tbname@l_name;
创建语法:
create database link linkname
connect to user
identified by usrpwd
using 'demona';