Oracle Message QSM-01053 - NORELY referential integrity constraint on table, string, in TRUSTED/STALE TOLERATED integrity mode

ERRORNORELY referential integrity constraint on table, string, in TRUSTED/STALE TOLERATED integrity mode
CAUSEA join present in the materialized view requires RELY mode to be set on the primary/foreign key constraints.
ACTIONSet the RELY mode with ALTER TABLE MODIFY CONSTRAINT RELY command. Alternatively validate the constraint with ALTER TABLE
VALIDATE CONSTRAINT .