为什么数据库出现大量需要重新编译的物化视图?重新编译后,隔天就又需要重新编译。
这些物化视图只是用于对原表的每日备份,创建语句为:
CREATE MATERIALIZED VIEW "FX"."HGH1109_MV"
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOG
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "BACK"
BUILD IMMEDIATE
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SIM"
REFRESH FORCE ON DEMAND
WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE
AS SELECT "T_FX_FUNDCHANGE_H"."OID" "OID","T_FX_FUNDCHANGE_H"."ACCOUNTOID" "AC
"CURRENYOID" "CURRENYOID","T_FX_FUNDCHANGE_H"."PRODUCTOID" "PRODUCTOID","T_FX_FU
NDCHANGE_H"."BUSSINESSWAY" "BUSSINESSWAY","T_FX_FUNDCHANGE_H"."TRADECOUNT" "TRAD
ECOUNT","T_FX_FUNDCHANGE_H"."CHANGETYPE" "CHANGETYPE","T_FX_FUNDCHANGE_H"."CHANG
EMONEY" "CHANGEMONEY","T_FX_FUNDCHANGE_H"."BALANCE" "BALANCE","T_FX_FUNDCHANGE_H
"."CHANGEDATE" "CHANGEDATE" FROM "T_FX_FUNDCHANGE_H" "T_FX_FUNDCHANGE_H";
修改如下也无法避免重新编译:
CREATE MATERIALIZED VIEW FXCHGH1116_MV_TEST
TABLESPACE BACK_REVERT
BUILD IMMEDIATE
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE SIMULATE
NEVER REFRESH
DISABLE QUERY REWRITE
AS SELECT * FROM T_FX_FUNDCHANGE_H;
|