QSM-02172

Error: QSM-02172: the SELECT list does not have the rowids of all the detail tables

Causa: If there are outer joins, unique constraints must exist on the join columns of the inner table. Otherwise, the materialized view can not be fast refreshable.

Acción: Add a UNION ALL marker column to each query block in the UNION ALL query defining the materialized view.