How to fix the Oracle error QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode?

In this post, you’ll learn more about the Oracle ErrorQSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode

Reason for the Error QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode

A join present in the materialized view requires validated primary/foreign key constraints in ENFORCED query rewrite integrity mode.

How to fix the Error QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode ?

You can fix this error in Oracle by following the below steps

Validate the constraint or change the integrity mode with ALTER SESSION SET QUERY_REWRITE_INTEGRITY = STALE_TOLERATED command.