Oracle两个数据库互相访问的sql脚本如下:
CREATE DATABASE LINK linkez CONNECT TO (用户名 )ezactor751ums IDENTIFIED BY (口令)ezactor751ums USING 'EZ_172.16.4.15'
建立好连接后可以进行sql语句的相就操作了
select * from joytest@linkez
insert into joytest@linkez (name,id,sex) values ('aaa','bbb','1')
delete from joytest@linkez
commit
linkez:建立连接后的别名
ezactor751ums :要连接另外一个数据库
'EZ_172.16.4.15':要连接的另外数据库的ip地址与数据库