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


QSM-01031: materialized view, string, is stale in TRUSTED
integrity mode



QSM-01031: materialized view, string, is stale in TRUSTED integrity mode..

Answer / guest

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

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 ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00000: normal, successful completion

1 Answers  


PLS-00602: CUBE and ROLLUP may appear only in a GROUP BY clause

1 Answers  


ORA-38491: could not evaluate subexpression for rowid "string"

1 Answers  


Why we can't perform DML operations on Materialized views???

1 Answers   CGI,


CLSR-00523: Resource string is not enabled

1 Answers  






TNS-00258: Number of Failed Requests : number

1 Answers  


PROT-00006: The specified import file cannot be found

1 Answers  


ORA-12227: TNS:syntax error

1 Answers  


ORA-38717: Invalid DUMP FLASHBACK option.

1 Answers  


ORA-02254: DEFAULT <expression> not allowed here

1 Answers  


ORA-15129: entry 'string' does not refer to a valid directory

1 Answers  


ORA-16217: prepare to switchover has not completed

1 Answers  






Categories