QSM-02177
MV with UNION ALL in a view must match the view's SELECT list
Cause
If a materialized view has a view whose definition involves a UNION ALL query, then the materialized view's select list must match the underlying view's select list exactly. It must not have any expressions and must not have add/drop/reorder columns from the underlying view.
Action
Use select * when defining a materialized view with a UNION ALL in a view.
QSM-02177
MV with UNION ALL in a view must match the view's SELECT list
Cause
If a materialized view has a view whose definition involves a UNION ALL query, then the materialized view's select list must match the underlying view's select list exactly. It must not have any expressions and must not have add/drop/reorder columns from the underlying view.
Action
Use select * when defining a materialized view with a UNION ALL in a view.
QSM-02177
MV with UNION ALL in a view must match the view's SELECT list
Cause
If a materialized view has a view whose definition involves a UNION ALL query, then the materialized view's select list must match the underlying view's select list exactly. It must not have any expressions and must not have add/drop/reorder columns from the underlying view.
Action
Use select * when defining a materialized view with a UNION ALL in a view.