ORA-32339: cannot alter materialized view with the PMOP



ORA-32339: cannot alter materialized view with the PMOP..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13030: Invalid dimension for the SDO_GEOMETRY object

2 Answers  


ORA-30733: cannot specify rowid constraint on scoped ref column

1 Answers  


NNL-01040: Data streams opened by server: number

1 Answers  


ORA-27084: unable to get/set file status flags

1 Answers  


LPX-00201: unknown encoding "~s"

1 Answers  


ORA-24769: cannot forget an active transaction

1 Answers  


DRG-10844: index cannot execute this structured predicate efficiently

1 Answers  


ORA-16066: remote archival disabled

1 Answers  


CLSS-00101: Oracle Cluster Repository mismatch with node string. (string != string)

1 Answers  


ORA-38101: Invalid column in the INSERT VALUES Clause: string

1 Answers  


QSM-02027: group by ROLLUP

1 Answers  


ORA-00251: LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string string

1 Answers  


Categories