QSM-01321: query rewrite not possible because materialized view string has TRUSTED constraints in ENFORCED integrity mode

QSM-01321: query rewrite not possible because materialized view string has TRUSTED constraints in ENFORCED integrity mode

Cause: A stale materialized view created with USING TRUSTED CONSTRAINTS clause cannot be used when the query rewrite integrity mode is set ENFORCED.

Action: Alter materialized view such that it has the ENFORCED CONSTRAINTS ALTER MATERIALIZED VIEW lamp;lt;lamp;nbsp;mvlamp;gt; REFRESH USING ENFORCED CONSTRAINTS