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-15173: entry 'string' does not exist in directory 'string'

1 Answers  


ORA-12668: Dedicated server: outbound protocol does not support proxies

1 Answers  


ORA-13050: unable to construct spatial object

1 Answers  


CLSR-06505: SERVICE_NAMES found null and fixed

1 Answers  


ORA-01184: logfile group string already exists

1 Answers  






ORA-14312: Value string already exists in partition string

1 Answers  


ORA-16098: inaccessible standby database forced shutdown to protect primary

1 Answers  


ORA-06019: NETASY: invalid login (connect) string

1 Answers  


ORA-28611: bitmap index is corrupted - see trace file for diagnostics

1 Answers  


ORA-23445: missing template site

1 Answers  


ORA-08457: syntax error in SEPARATE CHARACTER option of SIGN clause

1 Answers  


ORA-27127: unable to unlock shared memory segment

1 Answers  


Categories