QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode

QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode
Cause: A join present in the materialized view requires validated primary/foreign key constraints in ENFORCED query rewrite integrity mode.
Action: Validate the constraint or change the integrity mode with ALTER SESSION SET QUERY_REWRITE_INTEGRITY = STALE_TOLERATED command.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01052：参考完整性约束在表，字符串，而不是VALID在强制完整性模式,
.原因：呈现在实体化视图中的连接在ENFORCED查询重写完整性模式中需要经过验证的主键/外键约束。,
.操作：使用ALTER SESSION SET QUERY_REWRITE_INTEGRITY = STALE_TOLERATED命令验证约束或更改完整性模式。,
.

aiaiDBA

13718043309

010-86462881

QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode

1 个回答

相似问题