今天测试了一下利用materialized view同步数据[@more@]

source 端:

SQL> create table tt (id int,name varchar2(20));

Table created.

SQL> insert into tt values(1,'x');

1 row created.

SQL> commit;

Commit complete.

在target 端:

target端必须要有create materialized view,create database link的权限

SQL> create materialized view tt_mv as select * from tt@oracle10g;

Materialized view created.

SQL> select * from tt@oracle10g;

ID NAME

---------- ----------------------------------------

1 x

SQL> select * from tt_mv;

no rows selected

SQL> exec dbms_mview.refresh('tt_mv','c');

PL/SQL procedure successfully completed.

SQL> select * from tt_mv;

ID NAME

---------- ----------------------------------------

1 x

然后可以在target端创建一个job实时同步数据

ITPub博客

利用materialized view同步数据