重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-32339: cannot alter materialized view with the PMOP [打印本页]

作者: michaeljet 时间: 2016-9-1 16:05
标题: ORA-32339: cannot alter materialized view with the PMOP

Cause: the materialized view is notallowed to have destructive PMOPS such as

DROP, TRUNCATE and EXCHANGE (sub)partition. The UGA flagof i_am_a_

refresh should be set first.

Action: execute set_i_am_a_refreshfirst before alter materialized view with the

PMOP.

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)