Sunday 3 June 2012

ORA-32339: cannot alter materialized view with the PMOP

ORA-32339: cannot alter materialized view with the PMOP

Cause: the materialized view is not allowed to have destructive PMOPS such as DROP, TRUNCATE and EXCHANGE (sub)partition. The UGA flag of i_am_a_ refresh should be set first.

Action: execute set_i_am_a_refresh first before alter materialized view with the PMOP.

No comments:

Post a Comment