Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PCC-02328: undefined struct member

1 Answers  


NNL-00900: NO SUCH NAME responses sent: number

1 Answers  


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

1 Answers  


ORA-30156: Out of disk space

1 Answers  


ORA-36972: (XSRELTBL13) Relation workspace object must be dimensioned by workspace object.

1 Answers  






ORA-22927: invalid LOB locator specified

1 Answers  


ORA-02876: smpini: Unable to attach to shared memory for PGA

1 Answers  


TNS-12165: TNS:Trying to write trace file into swap space.

1 Answers  


ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.

1 Answers  


ORA-14159: duplicate subpartition name

1 Answers  


PLS-00364: loop index variable 'string' use is invalid

1 Answers  


KUP-04088: data sampling is not supported by this access driver

1 Answers  






Categories