aiaiDBA

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

13718043309

010-86462881

ORA-32316: REFRESH FAST of "string"."string" unsupported after mixed DML

ORA-32316: REFRESH FAST of "string"."string" unsupported after mixed DML
Cause: One or more of the materialized view logs on the detail tables referenced by the specified materialized view omits the sequence number option. Such a log cannot be used to refresh a materialized view after deletes or updates have been performed on multiple detail tables.
Action: Use REFRESH COMPLETE. Note: you can use the DBMS_MVIEW.EXPLAIN_MVIEW() API to determine which materialized view logs omit the sequence number option.

请先 登录 后评论

1 个回答

小智
ORA-32316:REFRESH FAST,“ string ”。混合DML后不支持“ string ”,
.原因:由指定实例化视图引用的详细信息表上的一个或多个物化视图日志省略序列号选项。在对多个详细信息表执行删除或更新后,此类日志无法用于刷新实例化视图。,
.操作:使用REFRESH COMPLETE。注意:可以使用DBMS_MVIEW.EXPLAIN_MVIEW()API确定哪些实例化视图日志省略序列号选项。,
.
请先 登录 后评论