QSM-02154: MV is not fast refreshable even with view merging

QSM-02154: MV is not fast refreshable even with view merging

Cause: You have a materialized view with view in the FROM clause, however it does not meet the criteria for fast refresh after view merging.

Action: Restructure the materialized view query to remove the offending view or the complex construct in the view.

No comments:

Post a Comment