aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

QSM-01121: materialized view, string, is TRUSTED in ENFORCED integrity mode

QSM-01121: materialized view, string, is TRUSTED in ENFORCED integrity mode
Cause: A stale materialized view created with USING TRUSTED CONSTRAINTS clause cannot be used when the query rewrite integrity mode is set ENFORCED.
Action: Alter materialized view such that it has the ENFORCED CONSTRAINTS ALTER MATERIALIZED VIEW REFRESH USING ENFORCED CONSTRAINTS

请先 登录 后评论

1 个回答

小智
QSM-01121:物化视图,字符串,在强制完整性模式下为TRUSTED,
.原因:当查询重写完整性模式设置为强制时,不能使用通过USING TRUSTED CONSTRAINTS子句创建的陈旧的实体化视图。,
.行动:改变物化视图,使其具有强制约束使用强制约束的更新,
.
请先 登录 后评论