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

ORA-27459: A program of type EXECUTABLE must have character-only arguments.

1 Answers  


ORA-01646: tablespace 'string' is not read only - cannot make read write

1 Answers  


NMP-00004: SNMP variable is read only

1 Answers  


ORA-14014: maximum number of partitioning columns is 16

1 Answers  


SQL*Loader-00604: Error occurred on an attempt to commit

1 Answers  


TNS-12641: Authentication service failed to initialize

1 Answers  


ORA-15054: disk "string" does not belong to diskgroup "string"

1 Answers  


QSM-02053: collection subquery in mv

1 Answers  


RMAN-08036: channel string: could not create controlfile record for string string

1 Answers  


ORA-00705: inconsistent state during start up; shut down the instance, then restart it

1 Answers  


ORA-02847: Server did not terminate when posted

1 Answers  


IMP-00030: failed to create file string for write

1 Answers  


Categories