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

ORA-29824: operator is invalid

1 Answers  


QSM-02184: Expression to enable PCT cannot be rolled up

1 Answers  


DRG-50927: parser failed on line string on column string

1 Answers  


ORA-38414: invalid datatype for the attribute string

1 Answers  


ORA-31193: This versioning feature isn't supported for resource string

1 Answers  






ORA-09290: sksaalo: error allocating memory for archival

1 Answers  


ORA-30734: cannot specify scope constraint on ref column with rowid

1 Answers  


NZE-29156: conditional RNG self-test failure

1 Answers  


ORA-12842: Cursor invalidated during parallel execution

2 Answers   ACC,


KUP-00552: internal XAD package failed to load

1 Answers  


ORA-16400: quota attributes are not allowed with DB_RECOVERY_FILE_DEST

1 Answers  


NZE-28835: Identity descriptor is not present or is too small.

1 Answers  


Categories