QSM-02174
the materialized view does not have a UNION ALL marker column
Cause
For a materialized view with UNION ALL to be fast refreshable, it must have a UNION ALL marker column. This is a constant column, at the same ordinal position in each query block and must have distinct values in each query block.
Action
Add a UNION ALL marker column to each query block in the UNION ALL query defining the materialized view.
QSM-02174
the materialized view does not have a UNION ALL marker column
Cause
For a materialized view with UNION ALL to be fast refreshable, it must have a UNION ALL marker column. This is a constant column, at the same ordinal position in each query block and must have distinct values in each query block.
Action
Add a UNION ALL marker column to each query block in the UNION ALL query defining the materialized view.
QSM-02174
the materialized view does not have a UNION ALL marker column
Cause
For a materialized view with UNION ALL to be fast refreshable, it must have a UNION ALL marker column. This is a constant column, at the same ordinal position in each query block and must have distinct values in each query block.
Action
Add a UNION ALL marker column to each query block in the UNION ALL query defining the materialized view.
