为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:centos7
【CPU】:x86
【问题描述】*:
物化视图定义:
create materialized view "AMLDATA"."MV_CLIENT_LEVEL_POLICY_NEW"
build immediate
refresh on demand with primary key fast
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_NEW 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'
创建的视图日志是基于rowid的:
create MATERIALIZED VIEW LOG on ODSINTF.CLIENT with ROWID;
create MATERIALIZED VIEW LOG on ODSINTF.POLICY with ROWID;
create MATERIALIZED VIEW LOG on AMLDATA.CLIENT_RISK_LEVEL_NEW with ROWID;
你将primary key换成rowid 再试试