Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.