ORA-32314: REFRESH FAST of "string"."string" unsupported after deletes/updates

ORA-32314: REFRESH FAST of "string"."string" unsupported after deletes/updates
Cause: One or more deletes or updates has been performed on one or more of the detail tables referenced by the specified materialized view. This materialized view does not support fast refresh after deletes or updates.
Action: Use REFRESH COMPLETE. Note: you can determine why your materialized view does not support fast refresh after deletes or updates using the DBMS_MVIEW.EXPLAIN_MVIEW() API.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

“ 字符串 ”的ORA-32314：REFRESH FAST 。删除/更新后不支持“ 字符串 ”,
.原因：对指定实例化视图引用的一个或多个详细信息表执行了一个或多个删除或更新。此实例化视图不支持在删除或更新后快速刷新。,
.操作：使用REFRESH COMPLETE。注意：您可以确定在使用DBMS_MVIEW.EXPLAIN_MVIEW（）API删除或更新后，您的物化视图不支持快速刷新的原因。,
.

aiaiDBA

13718043309

010-86462881

ORA-32314: REFRESH FAST of "string"."string" unsupported after deletes/updates

1 个回答

相似问题