--删除物化视图日志
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_view
using no index
refresh fast on commit
as
select rowid,
id
from table1
union all
select rowid,
id
from table2
union all
select rowid,
id
from table3;
创建即时刷新的物化视图
最新推荐文章于 2022-04-01 11:35:11 发布