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-24785: Cannot resume a non-migratable transaction

1 Answers  


ORA-19667: cannot do incremental restore of datafile string

1 Answers  


ORA-25204: invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP

1 Answers  


RMAN-02006: script line too long

1 Answers  


ORA-29967: Cannot drop an operator binding with dependent objects

1 Answers  






RMAN-05514: tablespace string has undo information, cannnot skip

1 Answers  


ORA-01113: file string needs media recovery

1 Answers  


TNS-12590: TNS:no I/O buffer

1 Answers  


LSX-00284: duplicate constraint name "~S"

1 Answers  


ORA-32406: cannot alter partitioning for existing materialized view log

1 Answers  


QSM-02115: mv references a remote object and is refreshed ON COMMIT

1 Answers  


NNO-00631: warning: forwarder number has invalid name "string", forwarder ignored

1 Answers  


Categories