为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:centos7
【CPU】:x86
【问题描述】:物化视图迁移失败(表[**]上不存在物化视图日志,无法进行快速刷新)
源oracle视图ddl如下:
CREATE MATERIALIZED VIEW "AMLDATA"."MV_CLIENT_LEVEL_POLICY" ("A_ROWID", "B_ROWID", "C_ROWID", "CLIENT_NO", "CLIENT_NAME", "SEX_NAME", "IDNO", "ID_TYPE", "ID_TYPE_NAME", "COUNTRY_CODE", "RISK_SCORE", "RISK_LEVEL", "RATE_DATE", "POSITION", "WORK_UNIT", "IDNO_VALIDITY_DATE", "BRANCH_CODE", "OCCUPATION_CODE", "OCCUP_ADD_DESC")
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "AMLTBS"
BUILD IMMEDIATE
USING INDEX
REFRESH FAST ON DEMAND
USING DEFAULT LOCAL ROLLBACK SEGMENT
USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE
AS SELECT A.rowid A_rowid,
B.rowid B_rowid,
C.rowid C_rowid,
a.client_no,
a.client_name,
decode(a.sex_code, '1', '男', '2', '女', '9', '未说明', '无关') sex_name,
a.idno,
a.id_type,
a.id_type_name,
a.country_code, /国籍/
c.risk_score, /等级分数/
c.risk_level, /等级/
c.rate_date, /评级日期/
a.position, /职务/
a.work_unit, /工作单位/
a.idno_validity_date,
b.branch_code,
a.occupation_code,
a.occup_add_desc
FROM CLIENT A, POLICY B, CLIENT_RISK_LEVEL C
WHERE C.CLIENT_NO = B.APPLICANT_NO
AND A.CLIENT_NO = C.CLIENT_NO
AND A.SYSTEM_TYPE = B.SYSTEM_TYPE
AND A.SYSTEM_TYPE <> '3'
;
物化视图的快速刷新依赖于基表上的物化视图日志,物化视图日志记录了基表的变化信息。需要创建物化视图日志