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


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-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

1 Answers  


ORA-25959: join index must be of the bitmap type

1 Answers  


ORA-39061: import mode string conflicts with export mode string

1 Answers  


PCC-00003: Invalid SQL Identifier at column number in line number of file string

1 Answers  


ORA-02832: Segment deallocation failed - segment not on list

1 Answers  






ORA-16621: Database name for ADD DATABASE must be unique.

1 Answers  


ORA-16541: site is not enabled

1 Answers  


LPX-00307: namespace prefix ~S used but not declared

1 Answers  


TNS-12678: Authentication disabled but required

1 Answers  


ORA-29295: invalid mime header tag

1 Answers  


ORA-36188: (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.

1 Answers  


RMAN-08055: media recovery complete

1 Answers  






Categories