ORA-12057: materialized view "string"."string" is INVALID and must complete refresh

ORA-12057: materialized view "string"."string" is INVALID and must complete refresh
Cause: The status of the materialized view was INVALID and an attempt was made to fast refresh the materialized view.
Action: Perform a complete refresh of the materialized view. Check the value of the STATUS column in dba_mviews, all_mviews, or user_mviews to verify that the materialized view is VALID after the complete refresh.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12057：物化视图“ 字符串 ”。“ 字符串 ”是INVALID，必须完成刷新,
.原因：实例化视图的状态为INVALID，并尝试快速刷新实例化视图。,
.操作：执行实例化视图的完全刷新。检查dba_mviews，all_mviews或user_mviews中的STATUS列的值，以在完成刷新后验证物化视图是否为VALID。,
.

aiaiDBA

13718043309

010-86462881

ORA-12057: materialized view "string"."string" is INVALID and must complete refresh

1 个回答

相似问题