Database Error Messages

QSM-02221

File Change Tracking (FCT) FAST REFRESH is not possible if the WHERE clause includes a subquery.

Cause

This capability is not supported because the materialized view query WHERE clause includes a subquery.


Action

Avoid using a subquery in the WHERE clause.