Database Error Messages

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

QSM-03222

The partition key of the fact table could not be related to the partition key of the MV.

Cause

The analysis by synchronous refresh indicated that the partition key of the fact table cannot be related to the partition key of the materialized view (MV).


Action

Check the partition keys of both the fact table and materialized view and the joins.