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

QSM-02137: agg(expr) requires correspondng STDDEV(expr) function

1 Answers  


NID-00100: Cannot open datafile "string"

1 Answers  


ORA-30379: query txt not specified

1 Answers  


ORA-38402: invalid name: empty string or spaces in the name

1 Answers  


ORA-13330: invalid MASK

1 Answers  






ORA-01528: EOF while processing SQL statement

1 Answers  


ORA-23378: connection qualifier "string" is not valid for object group "string"."string"

1 Answers  


ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices

1 Answers  


ORA-40223: data mining model import failed, job name=string, error=string

2 Answers  


ORA-12232: TNS:No path available to destination

1 Answers  


ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.

1 Answers  


KUP-04038: internal error: string

1 Answers  


Categories