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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

ORA-32339：不能用PMOP更改物化视图,
.原因：物化视图不允许具有破坏性PMOPS，例如DROP，TRUNCATE和EXCHANGE（子）分区。应首先设置i_am_a_refresh的UGA标志。,
.操作：在使用PMOP更改物化视图之前，先执行set_i_am_a_refresh。,
.

aiaiDBA

13718043309

010-86462881

ORA-32339: cannot alter materialized view with the PMOP

1 个回答

相似问题