ORA-32313: REFRESH FAST of "string"."string" unsupported
after PMOPs



ORA-32313: REFRESH FAST of "string"."string" unsupported after PMOPs..

Answer / guest

Cause: A Partition Maintenance Operation (PMOP) has been
performed on a detail table, and the specified materialized
view does not support fast refersh after 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 ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

0 Answers  


ORA-32505: too many watchpoints

1 Answers  


ORA-27473: argument string does not exist

1 Answers  


ORA-14512: cannot perform operation on a clustered object

1 Answers  


PLS-00205: Aggregate not allowed here

1 Answers  






CLSR-00003: ORACLE_HOME environment variable not set

1 Answers  


QSM-00506: no fact-tables could be found

1 Answers  


ORA-06925: CMX: disconnect during connect request

1 Answers  


SQL-02102: Inconsistent cursor cache. No global cursor entry.

1 Answers  


RMAN-06094: datafile string must be restored

1 Answers  


ORA-26033: Direct path operation not supported on table with encrypted colum

1 Answers  


ORA-06317: IPA: Local maximum number of users exceeded

1 Answers  


Categories