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

NZE-29232: the cryptographic engine key initialization failed

1 Answers  


CLSR-06500: Invalid input arguments

1 Answers  


ORA-29256: Cursor contains both regular and array defines which is illegal

1 Answers  


ORA-09947: Unable to allocate connection attributes structure

1 Answers  


SQL*Loader-00478: unable to continue due to missing filename for LOBFILE or SDF

1 Answers  


ORA-25218: enqueue failed, delay must be zero for queue string.string

1 Answers  


ORA-12424: length exceeds binary label size

1 Answers  


ORA-16572: Data Guard configuration file not found

1 Answers  


RMAN-06577: FROM TAG option may only be used with datafilecopies

1 Answers  


ORA-13616: The current user string has not been granted the ADVISOR privilege.

1 Answers  


ORA-30202: NULL pointer to OCIMsgh was passed to OCIMsg function

1 Answers  


ORA-29865: indextype is invalid

1 Answers  


Categories