QSM-01052: referential integrity constraint on table,
string, not VALID in ENFORCED integrity mode
- 1 Answers
- 2655 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 |
ORA-32839: property string is reserved, names with MGWPROP$_ prefix are not valid
ORA-00337: log file 'string' does not exist and no size specified
ORA-33214: (CINSERT02) The workspace object dimension is too large.
ORA-12451: label not designated as USER or DATA
ORA-30039: Cannot drop the undo tablespace
ORA-01412: zero length not allowed for this datatype
PCC-02382: You must specify MODE=ANSI when using NLS_LOCAL=YES
QSM-01621: join backs to base tables not allowed with an equivalence
TNS-00131: Missing COMMUNITY in COMMUNITY_COST_LIST in TNSNET.ORA
PCC-00113: Value of DBMS option invalid with given value of MODE option
ORA-07268: szguns: getpwuid error.
ORA-02024: database link not found
Oracle Errors 
