Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01031: materialized view, string, is stale in TRUSTED
integrity mode
- 1 Answers
- 3112 Views
- I also Faced
- E-Mail Answers
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 |
ORA-24433: This statement has already been prepared using OCIStmtPrepare2.
ORA-13758: "SQL Tuning Set" "string" is in use.
ORA-23339: duplicate conflict resolution information
ORA-07721: scgcm: not enough OS resource to obtain system enqueue
ORA-26025: SKIP_INDEX_MAINTENANCE option requested
ORA-12451: label not designated as USER or DATA
NNL-00986: Reforwarded requests expired: number
RMAN-06141: cannot specify ARCHIVELOG LIKE option with RESTORE
ORA-31211: DBMS_LDAP: PL/SQL - Invalid LDAP entry dn.
RMAN-20503: DELETE cannot delete expired objects - run CROSSCHECK or DELETE EXPIRED
LFI-00150: Error on creating hash table in function string
PCC-02450: Cursor was not declared in scrollable mode
Oracle Errors 
