Database Error Messages

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

QSM-02123

subquery and UNION mv's must be primary key mv's

Cause

The capability in question is not supported when the materialized view is not a primary key materialized view and uses subqueries or the union operator in this context.


Action

Re-create the materialized view as a primary key materialized view.