QSM-01053: NORELY referential integrity constraint on table, string, in TRUSTED or STALE TOLERATED integrity mode
Cause: A join present in the materialized view requires RELY mode to be set on the primary or foreign key constraints.
Action: Set the RELY mode with ALTER TABLE lamp;lt;lamp;nbsp;tablelamp;gt; MODIFY CONSTRAINT lamp;lt;lamp;nbsp;constraintlamp;gt; RELY command. Alternatively validate the constraint with ALTER TABLE lamp;lt;lamp;nbsp;tablelamp;gt; VALIDATE CONSTRAINT lamp;lt;lamp;nbsp;constraintlamp;gt;.
Cause: A join present in the materialized view requires RELY mode to be set on the primary or foreign key constraints.
Action: Set the RELY mode with ALTER TABLE lamp;lt;lamp;nbsp;tablelamp;gt; MODIFY CONSTRAINT lamp;lt;lamp;nbsp;constraintlamp;gt; RELY command. Alternatively validate the constraint with ALTER TABLE lamp;lt;lamp;nbsp;tablelamp;gt; VALIDATE CONSTRAINT lamp;lt;lamp;nbsp;constraintlamp;gt;.
No comments:
Post a Comment