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



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

Answer / guest

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

Action: Set the RELY mode with ALTER TABLE <table> MODIFY
CONSTRAINT <constraint> RELY command. Alternatively validate
the constraint with ALTER TABLE <table> VALIDATE CONSTRAINT
<constraint>.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-10651: incorrect file number block number specified

1 Answers  


ORA-07273: sppst: invalid semaphore id.

1 Answers  


NZE-28810: Cannot create key descriptor.

1 Answers  


ORA-02074: cannot string in a distributed transaction

1 Answers  


PLS-00396: INSERT statement's subquery yields wrong number of columns

1 Answers  






ORA-01525: error in renaming data files

1 Answers  


IMP-00091: Above error occurred on the following function and object: string. Remaining PL/SQL blocks for this object will be skipped.

1 Answers  


ORA-01182: cannot create database file string - file is in use or recovery

1 Answers  


ORA-28505: cannot get non-Oracle system capabilities from string

1 Answers  


NNL-00261: Request forwarding is currently enabled

1 Answers  


TNS-12671: Shared server: adapter failed to save context

1 Answers  


QSM-01565: equivalence, string, cannot compute measure, string, in the query

1 Answers  


Categories