ORA-32315: REFRESH FAST of “string”.”string” unsupported after mixed DML and Direct Load

oracle

ORA-32315: REFRESH FAST of "string"."string" unsupported after mixed DML and Direct Load
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 and direct path insert
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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/