创建即时刷新的物化视图

--删除物化视图日志drop materialized view log on table1;drop materialized view log on table2;drop materialized view log on table3;--删除物化视图drop materialized view mv_view;--创建物化视图日志create materialized view log on table1 with rowid including new values;create materialized view log on table2 with rowid including new values;create materialized view log on table3 with rowid including new values;--物化视图create materialized view mv_viewusing no indexrefresh fast on commitasselect rowid,       id  from table1union allselect rowid,       id  from table2union allselect rowid,       id  from table3;