ORA-32320: REFRESH FAST of "string"."string" unsupported
after container table PMOPs

Answers were Sorted based on User's Feedback



ORA-32320: REFRESH FAST of "string"."string" unsupported after container table ..

Answer / guest

Cause: A Partition Maintenance Operation (PMOP) has been
performed on the materialized view, and no materialized view
supports fast refersh after container table PMOPs.

Action: Use REFRESH COMPLETE. Note: you can determine why
your materialized view does not support fast refresh after
PMOPs using the DBMS_MVIEW.EXPLAIN_MVIEW() API.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

ORA-32320: REFRESH FAST of "string"."string" unsupported after container table ..

Answer / mahesh

If the Table is not a Partitioned one then also it is
throwing the same exception.

How is this possible.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16788: Unable to set one or more database configuration property values

1 Answers  


NNC-00421: invalid modification directive string, must be between string and string

1 Answers  


ORA-33462: (ESDREAD10A) Discarding compiled code for workspace object because object number is not in analytic workspace string.

1 Answers  


PCC-02108: UNSAFE_NULL=YES allowed if MODE=ORACLE and DBMS=V7 or V8

1 Answers  


ORA-39065: unexpected master process exception in string

1 Answers  






ORA-09284: sllfop: cannot allocate read buffer

1 Answers  


ORA-25241: cannot change correlation ID from string to string without FIRST_MESSAGE option

1 Answers  


ORA-08458: invalid format parameter

1 Answers  


TNS-03503: Could not initialize NL

1 Answers  


ORA-13458: GeoRaster metadata SRS error

1 Answers  


QSM-01081: no primary key or row id found for table, string, in MV, string

1 Answers  


ORA-39088: file name cannot contain a path specification

1 Answers  


Categories