物化视图在UPDATE、DELETE时怎么更新

[haidywei]

create materialized view DNIFMC.AGG_L_SENDPKG_T_FCDR_LOG_P2P
tablespace FMC_DATA
refresh fast on commit
with primary key
enable query rewrite
as
SELECT
"DNIFMC"."T_FCDR_LOG_P2P"."TIME_BLOCK_ID" AS "TIME_BLOCK_ID",
SUM("DNIFMC"."T_FCDR_LOG_P2P"."SENDPKG") AS "SENDPKG",
COUNT(*) AS "fact_count"
FROM
"DNIFMC"."T_FCDR_LOG_P2P"
GROUP BY
"DNIFMC"."T_FCDR_LOG_P2P"."TIME_BLOCK_ID";
以上是我的物化视图脚本，源表在UPDATE和DELETE时物化视图都没有更新，但日志表记录UPDATE和DELETE，只有在INSERT时物化视图才有更新，请问要怎样才能让物化视图在所有情况下都自动更新

[f0310]

有几种可能：
1. UPDATE和DELETE没有commit
2. UPDATE和DELETE之后结果是一样的，看不出来变化
3. UPDATE和DELETE引起物化视图refresh的错误，检查一下alertlog

[bjt_]

帮顶

[chris_hjq]

楼主可以用sql plus手动改些数据试试就知道了

[meiZiNick]

有点难度哦