Database Error Messages

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

QSM-02148

many to many subquery joins require 9.0 compatibility or higher

Cause

You have specified a many to many join in your materialized view while running in less than 9.0 compatibility mode.


Action

Set your compatibility mode to 9.0 or higher or restructure the materialized view query.