Oracle Error QSM-02186: PARTITIONED OUTER JOIN is present

Oracle Error Message

QSM-02186: PARTITIONED OUTER JOIN is present

Reason for the Error

The capability in question is not supported when the materialized view has PARTITIONED OUTER JOIN.

Solution

Remove PARTITIONED OUTER JOIN.