建的日志
CREATE MATERIALIZED VIEW LOG ON t
WITH ROWID , SEQUENCE (AREA_ID,STATE ,deal_state,CRM_ALERT_LEVEL)
INCLUDING NEW VALUES;
物化视图脚本
CREATE MATERIALIZED VIEW FJIT.mv_PROD_FZ_CRM_WORKORDER
TABLESPACE RES_CONF_DATA
NOCACHE
LOGGING
NOPARALLEL
BUILD IMMEDIATE
USING INDEX
TABLESPACE users
REFRESH fast ON DEMAND
WITH ROWID
AS
Select t2.area_id,
SUM(CASE WHEN deal_state != 2 AND t2.state != '5SC' THEN 1 ELSE 0 END ) AS ncrms ,
SUM(CASE WHEN deal_state != 2 AND t2.crm_alert_level != 0 and t2.state !='5SC' AND deal_state != 2THEN 1 ELSE 0 END ) AS lcrms
From t t2
Group By t2.area_id;
我本想这样子一样,刷新物化视图就是可以使用日志 ,并采用fast方式来更新
可是出错了。
9:07:54 SQL> exec dbms_mview.refresh('mv_t');
begin dbms_mview.refresh('mv_t'); end;
ORA-32314: REFRESH FAST of "FJIT"."MV_t" unsupported after deletes/updates
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 820
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 877
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 858
我想问,怎么样才能让刷新可以使用fast的方式,谢谢
祝国庆提前快乐!
|