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

ORA-00251: LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string string

1 Answers  


ORA-01412: zero length not allowed for this datatype

1 Answers  


ORA-01484: arrays can only be bound to PL/SQL statements

1 Answers  


TNS-12231: TNS:No connection possible to destination

1 Answers  


ORA-19733: COMPATIBLE parameter needs to be string or greater

1 Answers  


TNS-00545: parameter retrieval failure

1 Answers  


ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped

1 Answers  


NNL-00993: Auto-refresh failure retry expiration: string

1 Answers  


PCC-00140: CREATE FUNCTION/PROCEDURE/PACKAGE/TRIGGER are Oracle extensions

1 Answers  


ORA-29811: missing STATISTICS keyword

1 Answers  


NCR-03020: NCRO: Invalid call context

1 Answers  


TNS-04037: Connections refer to string.

1 Answers  


Categories