Oracle Error QSM-02197: PCT FAST REFRESH is not possible if query contains a remote table

Oracle Error Message

QSM-02197: PCT FAST REFRESH is not possible if query contains a remote table

Reason for the Error

The capability in question was not supported because the materialized view query contained a remote table.

Solution

Rephrase the query to avoid the use of a remote table.