●使用数据库链接
1、创建数据库连接
CREATE DATABASE LINK LNK_NAME CONNECT TO USER_NAME IDENTIFIED BY PWD USING 'DEST_DB_SERVER_NAME'
2、关闭数据库,更改init.ora中global_names = false
3、启动数据库
4、在源数据库中操作目的表 select * from TABLE@LNK_NAME
●需要时时同步的表,建触发器(但会影响效率)
1、创建数据库连接
CREATE DATABASE LINK LNK_NAME CONNECT TO USER_NAME IDENTIFIED BY PWD USING 'DEST_DB_SERVER_NAME'
2、关闭数据库,更改init.ora中global_names = false
3、启动数据库
4、在源数据库中操作目的表 select * from TABLE@LNK_NAME
●需要时时同步的表,建触发器(但会影响效率)
Stream concept and Samples
http://www.oracle.com/technology/oramag/oracle/04-nov/o64streams.htmlOracle Streams Samples and Best Practices
http://www.oracle.com/technology/sample_code/tech/streams/index.html