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-09767: osnmfs: bad return code from msg_send.

1 Answers  


ORA-12430: invalid privilege number

1 Answers  


ORA-00445: background process "string" did not start after string seconds

1 Answers  


KUP-00562: unknown escape sequence

1 Answers  


ORA-14003: GLOBAL clause contradicts previosly specified LOCAL clause

1 Answers  






ORA-23415: materialized view log for "string"."string" does not record the primary key

1 Answers  


ORA-27469: %s is not a valid string attribute

1 Answers  


ORA-25219: enqueue failed, sequence deviation not allowed for queue string.string

1 Answers  


LSX-00123: base type is required

1 Answers  


TNS-12564: TNS:connection refused

6 Answers   Oracle,


ORA-26097: unsupported conversion for column string (from type number to type number)

1 Answers  


PLS-00920: parameter plsql_native_library_dir is not set

1 Answers  


Categories