QSM-01053: NORELY referential integrity constraint on table,
string, in TRUSTED/STALE TOLERATED integrity mode
- 1 Answers
- 3380 Views
- I also Faced
- E-Mail Answers
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 |
ORA-22343: Compilation error for type invalidated by ALTER TYPE
ORA-23533: object "string"."string" can not be cached
ORA-16724: the intended state for the database has been set to OFFLINE
DGM-16992: You must shut down instance "string" manually.
ORA-30108: invalid positional parameter value 'string'
PLS-00105: at most one forward declaration of type 'string' is permitted
IMP-00080: Error during character conversion of long column or long command
ORA-01202: wrong incarnation of this file - wrong creation time
ORA-24350: OCI call not allowed
RMAN-03040: Spooling for trace turned off
TNS-12534: TNS:operation not supported
ORA-23400: invalid materialized view name "string"
Oracle Errors 
