QSM-01052: referential integrity constraint on table,
string, not VALID in ENFORCED integrity mode
- 1 Answers
- 3012 Views
- I also Faced
- E-Mail Answers
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 |
NID-00305: Datafile string - already changed
ORA-01259: unable to delete datafile string
NNO-00051: domain count number exceeds maximum of number, first number will be loaded
ORA-09889: osnTXtt: access error on oracle executable
ORA-32342: The EXPLAIN_MVIEW facility failed to explain the materialized view statement
IMG-02007: 2FF07 - positional color feature cannot be determined
ORA-27057: cannot perform async I/O to file
ORA-28234: key length too short
ORA-08275: Environment variable unset
ORA-30503: system triggers cannot have a REFERENCING clause
PLS-00419: reference to remote attribute not permitted
ORA-12707: error while getting create database NLS parameter string
Oracle Errors 
