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

NNL-00930: Requests refused, unknown data type: number

1 Answers  


PCB-00003: Value of DBMS option invalid with given value of MODE option

1 Answers  


ORA-38706: Cannot turn on FLASHBACK DATABASE logging.

1 Answers  


ORA-02441: Cannot drop nonexistent primary key

1 Answers  


ORA-12631: Username retrieval failed

2 Answers  






KUP-04030: invalid numeric data

1 Answers  


ORA-03251: Cannot issue this command on SYSTEM tablespace

1 Answers  


ORA-36403: (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.

1 Answers  


ORA-25195: invalid option for index on an index-organized table

1 Answers  


DRG-11425: gist level string is invalid

1 Answers  


PLS-00222: no function with name 'string' exists in this scope

1 Answers   QuinStreet,


ORA-12078: fast refresh of refresh group ID string failed

1 Answers  


Categories