Oracle Error QSM-02203: PCT FAST REFRESH is not possible if query has set operand query blocks

Oracle Error Message

QSM-02203: PCT FAST REFRESH is not possible if query has set operand query blocks

Reason for the Error

The capability in question was not supported because the materialized view query contained set operand query blocks.

Solution

Rephrase the query to avoid the use of set operand query blocks.