1、创建数据库链
2、在源数据库上创建表的物化日志
create materialized view log on user_info with rowid
drop materialized view log on user_info
3、在目表数据库上创建物化视图(2分钟更新)
CREATE MATERIALIZED VIEW T_TEST_MV REFRESH FAST ON DEMAND WITH ROWID START WITH SYSDATE NEXT SYSDATE + 2/(24*60) AS
select * from user_info@TEST