Oracle Error QSM-02112: top level query has LEFT OUTER, RIGHT OUTER or FULL OUTER join

Oracle Error Message

QSM-02112: top level query has LEFT OUTER, RIGHT OUTER or FULL OUTER join

Reason for the Error

The capability in question is not supported when the materialized view uses these types of joins.

Solution

Re-phrase the query to avoid the use of these types of joins.