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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

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

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题