Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-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.