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

PLS-01910: : associative array shape is not consistent with session parameters

1 Answers  


ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded

1 Answers  


ORA-02324: more than one column in the SELECT list of THE subquery

1 Answers  


NZE-28819: No distinguished name provided.

1 Answers  


ORA-01298: conflicting dictionary option

1 Answers  


ORA-10633: No space found in the segment

1 Answers  


PLS-00533: Tables of non_queryable types are not supported.

1 Answers  


ORA-16205: DDL skipped due to skip setting

1 Answers  


PLS-00331: illegal reference to string

1 Answers  


PCC-00115: Array required here

1 Answers  


ORA-02461: Inappropriate use of the INDEX option

1 Answers  


ORA-37070: You may not execute OLAP DML programs in a parallel query session.

1 Answers  


Categories