Database Error Messages

ORA-31907

Synchronous refresh of "string"."string" results in rows which do not belong to any of the materialized view's partitions.

Cause

Synchronous refresh detected this error during PREPARE_REFRESH.


Action

Check the data in the staging logs of the materialized view's base tables for validity. If the data is valid, create additional partitions, including a default partition if needed, with the ALTER MATERIALIZED VIEW command.