方法一:
- CREATE DATABASE LINK link_1
- CONNECT TO dengm IDENTIFIED BY dengm
- USING '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.148)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl102g)))'
方法二:
create public database link dblink_test
connect to aaa identified by bbb
using 'BEJING';
再建立触发器,可以实现不同数据库之间的同步