利用materialized view同步資料

今天測試了一下利用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實時同步資料