-- 在source db 上创建物化视图

SQL> conn scott/oracle


SQL> create table test (id int primary key);


Table created.



SQL> create materialized view log on test;


Materialized view log created.


-- 在目标端创建db link


SQL> conn scott/oracle

Connected.

SQL> create database link PREMIUMI connect to scott identified by oracle using 'source_db';


Database link created.


SQL> select * from test@PREMIUMI;


no rows selected


create materialized view test refresh fast start with sysdate next sysdate+1/(1440*60) with primary key as select * from test@PREMIUMI;



SQL> create materialized view test refresh fast start with sysdate next sysdate+1/(1440*60) with primary key as select * from test@PREMIUMI;


Materialized view created.




--测试

source db


SQL> insert into test values (1);


1 row created.


SQL> commit;


Commit complete.


-- target db

SQL> select * from test;


       ID

----------

        1