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

NPL-00309: requested ASN.1 type tag string does not match received type tag string

1 Answers  


ORA-16508: channel handle not initialized

1 Answers  


NMP-00008: SNMP message has incorrect version, version 0 is required

1 Answers  


ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped

1 Answers  


LSX-00008: feature "~s" is not implemented

1 Answers  






ORA-24025: invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type

1 Answers  


EXP-00053: unable to execute QUERY on table string because the table has inner nested tables

1 Answers  


ORA-29310: database is not open, or opened as a clone

1 Answers  


ORA-02024: database link not found

1 Answers  


ORA-14321: cannot add/drop values to DEFAULT partition

1 Answers  


TNS-01070: Starting string: please wait...

1 Answers  


QSM-02072: requirements not satisfied for fast refresh of nested mv

1 Answers  


Categories