Oracle Error QSM-02170: tables must be identical across the UNION operator

Oracle Error Message

QSM-02170: tables must be identical across the UNION operator

Reason for the Error

You have specified a materialized view using the UNION operator and the tables on each side of the UNION operator do not match. Fast refresh is not supported in this context.

Solution

Restructure the materialized view query such that the respective sides of the UNION operator have the same table.