文档解释 ORA-32314: REFRESH FAST of “string”.”string” unsupported after deletes/updates Cause: One o
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.
ORA-32314: REFRESH FAST of “string”.”string” unsupported after deletes/updates 错误表明不支持在执行UPDATE和DELETE操作之后使用REFRESH FAST语句刷新索引组合(indexed clusters)。
1.检查是否更新或删除表中的数据。
2.检查刷新语句包含了REFRESH FAST。
3.更改REFRESH FAST命令为REFRESH COMPLETE或REFRESH FORCE,然后再次尝试刷新索引组合。
--结束END--
本文标题: ORA-32314: REFRESH FAST of “string”.”string” unsupported after deletes/updat
本文链接: https://lsjlt.com/news/534065.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0