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

Oracle 6 Views 0 Min Read

Oracle Error Message

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

Reason for the Error

A join present in the materialized view requires RELY mode to be set on the primary/foreign key constraints.

Solution

Set the RELY mode with ALTER TABLE

MODIFY CONSTRAINT RELY command. Alternatively validate the constraint with ALTER TABLE

VALIDATE CONSTRAINT .

Tags: