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.
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.
No comments:
Post a Comment