Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-24409: client cannot understand the object

1 Answers  


ORA-23447: missing user parameter value

1 Answers  


DRG-11618: URL store: document identified by string is too large

1 Answers  


ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.

1 Answers  


ORA-37028: (XSMLTRESYNC03) Object workspace object cannot be resynced without modified object workspace object because they share a modified dimension map.

1 Answers  






ORA-22335: The client cannot work with an altered type

1 Answers  


ORA-13774: insufficient privileges to select data from the workload repository

1 Answers  


ORA-12200: TNS:could not allocate memory

1 Answers  


RMAN-08024: channel string: restore complete

1 Answers  


RMAN-04032: using contents of file string

1 Answers  


ORA-13617: The specified task string already executing

1 Answers  


PCC-02047: CMD-LINE: Option is not allowed inline:

1 Answers  






Categories