QSM-01031: materialized view, string, is stale in TRUSTED
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|
LPX-00000: normal, successful completion
PLS-00602: CUBE and ROLLUP may appear only in a GROUP BY clause
ORA-38491: could not evaluate subexpression for rowid "string"
Why we can't perform DML operations on Materialized views???
CLSR-00523: Resource string is not enabled
TNS-00258: Number of Failed Requests : number
PROT-00006: The specified import file cannot be found
ORA-12227: TNS:syntax error
ORA-38717: Invalid DUMP FLASHBACK option.
ORA-02254: DEFAULT <expression> not allowed here
ORA-15129: entry 'string' does not refer to a valid directory
ORA-16217: prepare to switchover has not completed