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 or drop or reorder columns from the underlying view.
Action: Use select * when defining a materialized view with a UNION ALL in a view.
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 or drop or reorder columns from the underlying view.
Action: Use select * when defining a materialized view with a UNION ALL in a view.
No comments:
Post a Comment