重庆思庄Oracle、Redhat认证学习论坛
标题: ORA-32316: REFRESH FAST of "string"."string" [打印本页]
作者: michaeljet 时间: 2016-9-1 15:55
标题: ORA-32316: REFRESH FAST of "string"."string"
ORA-32316: REFRESH FAST of "string"."string"unsupported after mixed DML
Cause: One or more of thematerialized view logs on the detail tables referenced
by the specified materialized view omits the sequencenumber option. Such a log
cannot be used to refresh a materialized view afterdeletes 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 materializedview logs omit
the sequence number option.
欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) |
Powered by Discuz! X3.2 |