QSM-01029: materialized view, string, is stale in ENFORCED
integrity mode



QSM-01029: materialized view, string, is stale in ENFORCED integrity mode..

Answer / guest

Cause: A stale materialized view cannot be used for query
rewrite when the query rewrite integrity mode is set to
ENFORCED.

Action: Refresh the materialized view or alter the rewrite
integrity mode with ALTER SESSION QUERY_REWRITE_INTEGRITY =
STALE TOLERATED command.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00352: Cancelled save config

1 Answers  


ORA-16184: DB_UNIQUE_NAME string hashes to the same value as DB_UNIQUE_NAME string

1 Answers  


TNS-01158: Internal connection limit reached, preventing dispatcher from connecting

1 Answers  


ORA-19719: length for operation name longer than string

1 Answers  


ORA-16221: history table synchronization error

1 Answers  






ORA-15123: ASM file name 'string' contains an invalid incarnation number

1 Answers  


ORA-16610: one or more resources have warnings

1 Answers  


ORA-10638: Index status is invalid

1 Answers  


ORA-29541: class string.string could not be resolved

1 Answers  


NNL-00039: no RRs

1 Answers  


ORA-03288: both FREELIST GROUP and INSTANCE parameters may not be specified

1 Answers  


ORA-09914: Unable to open the ORACLE password file.

1 Answers  


Categories