Saturday 2 June 2012

ORA-32313: REFRESH FAST of string . string unsupported after PMOPs

ORA-32313: REFRESH FAST of string . string unsupported after PMOPs

Cause: A Partition Maintenance Operation (PMOP) has been performed on a detail table, and the specified materialized view does not support fast refersh after 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