Database Error Messages

QSM-02225

Materialized view does not contain the FMARKER of the referenced external table.

Cause

File Change Tracking (FCT) FAST REFRESH after a modification or deletion of files is not supported because the materialized view does not contain the FMARKER of the referenced external table.


Action

Include the FMARKER of the referenced external table by adding DBMS_MVIEW.FMARKER() to the SELECT list of the materialized view query, and to the GROUP BY list where applicable.