Saturday, 2 June 2012

ORA-32320: REFRESH FAST of string . string unsupported after container table PMOPs

ORA-32320: REFRESH FAST of string . string unsupported after container table PMOPs

Cause: A Partition Maintenance Operation (PMOP) has been performed on the materialized view, and no materialized view supports fast refersh after container table PMOPs.

Action: Use REFRESH COMPLETE. Note: you can determine why your materialized view does not support fast refresh after PMOPs using the DBMS_ MVIEW.EXPLAIN_MVIEW() API.

No comments:

Post a Comment