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

IMG-00922: location specified without feature

1 Answers  


ORA-31686: error creating worker processes

1 Answers  


QSM-00774: there are no SQL statements to process for task string

1 Answers  


QSM-02118: duplicate grouping sets

1 Answers  


PCB-00502: This statement can only be used with THREADS=YES

1 Answers  


ORA-12618: TNS:versions are incompatible

1 Answers  


ORA-02284: duplicate INCREMENT BY specifications

1 Answers  


CLSR-06502: Failed to connect to database

1 Answers  


NID-00131: Control file is not current

1 Answers  


PLW-05001: previous use of 'string' (at line string) conflicts with this use

1 Answers  


SQL*Loader-00294: invalid name % specified in TREAT AS clause

1 Answers  


ORA-12007: materialized view reuse parameters are inconsistent

1 Answers  


Categories