QSM-01052: referential integrity constraint on table,
string, not VALID in ENFORCED integrity mode



QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode..

Answer / guest

Cause: A join present in the materialized view requires
validated primary/foreign key constraints in ENFORCED query
rewrite integrity mode.

Action: Validate the constraint or change the integrity mode
with ALTER SESSION SET QUERY_REWRITE_INTEGRITY =
STALE_TOLERATED command.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27158: process control failure

1 Answers  


IMG-00712: unable to write to destination image

1 Answers  


ORA-13633: The task string was interrupted and needs to be resumed.

1 Answers  


PLS-00565: %s must be completed as a potential REF target (object type)

1 Answers  


ORA-14501: object is not partitioned

1 Answers  






TNS-00084: * trace_off - ask process name to turn tracing off

1 Answers  


ORA-16627: No standby databases support the overall protection mode.

0 Answers   Oracle,


ORA-13115: [string]_EDGE$ table does not exist

1 Answers  


ORA-00123: idle public server terminating

1 Answers  


LFI-00105: Unable to add path.

1 Answers  


ORA-23476: cannot import from string to string

1 Answers  


ORA-04073: column list not valid for this trigger type

1 Answers  


Categories