CREATE MATERIALIZED VIEW LOG ON TABLE1 WITH ROWID
(COLA)
INCLUDING NEW VALUES;CREATE MATERIALIZED VIEW MV_A
PCTFREE 0 TABLESPACE TBS_RQ_MNG
STORAGE (INITIAL 8M)
PARALLEL
BUILD IMMEDIATE
REFRESH FAST
ON COMMIT
DISABLE QUERY REWRITE AS
SELECT COLA,COUNT(*) COU
FROM TABLE1
GROUP BY COLA ;当对TABLE1 做DELETE操作时,该视图MV_A就失效了。
用SELECT MVIEW_NAME, LAST_REFRESH_DATE, STALENESS FROM USER_MVIEWS;
查询出来STALENESS 是UNUSABLE状态INSERT和 UPDATE都是正常的
(COLA)
INCLUDING NEW VALUES;CREATE MATERIALIZED VIEW MV_A
PCTFREE 0 TABLESPACE TBS_RQ_MNG
STORAGE (INITIAL 8M)
PARALLEL
BUILD IMMEDIATE
REFRESH FAST
ON COMMIT
DISABLE QUERY REWRITE AS
SELECT COLA,COUNT(*) COU
FROM TABLE1
GROUP BY COLA ;当对TABLE1 做DELETE操作时,该视图MV_A就失效了。
用SELECT MVIEW_NAME, LAST_REFRESH_DATE, STALENESS FROM USER_MVIEWS;
查询出来STALENESS 是UNUSABLE状态INSERT和 UPDATE都是正常的
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货