create materialized view log on products; 先创建日志
create materialized view mv_product_order
BUILD IMMEDIATE ----创建时生成数据 注意位置
refresh fast With PRIMARY KEY 增量刷新 主键
on commit 在基表有更新时提交
as select pid,pname,quantity from products;
select * from mv_product_order;
create materialized view mv_product_order
BUILD IMMEDIATE ----创建时生成数据 注意位置
refresh fast With PRIMARY KEY 增量刷新 主键
on commit 在基表有更新时提交
as select pid,pname,quantity from products;
select * from mv_product_order;