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

NID-00305: Datafile string - already changed

1 Answers  


ORA-01259: unable to delete datafile string

1 Answers  


NNO-00051: domain count number exceeds maximum of number, first number will be loaded

1 Answers  


ORA-09889: osnTXtt: access error on oracle executable

1 Answers  


ORA-32342: The EXPLAIN_MVIEW facility failed to explain the materialized view statement

1 Answers  


IMG-02007: 2FF07 - positional color feature cannot be determined

1 Answers  


ORA-27057: cannot perform async I/O to file

1 Answers  


ORA-28234: key length too short

1 Answers  


ORA-08275: Environment variable unset

1 Answers  


ORA-30503: system triggers cannot have a REFERENCING clause

1 Answers  


PLS-00419: reference to remote attribute not permitted

1 Answers  


ORA-12707: error while getting create database NLS parameter string

1 Answers  


Categories