Oracle Error QSM-02148: many to many subquery joins require 9.0 compatibility or higher

Oracle Error Message

QSM-02148: many to many subquery joins require 9.0 compatibility or higher

Reason for the Error

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

Solution

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