Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01031: materialized view, string, is stale in TRUSTED
integrity mode
- 1 Answers
- 3119 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-04088: error during execution of trigger 'string.string'
ORA-24402: error occured while creating connections in the pool
ORA-14059: partition "string": INITRANS value must be less than MAXTRANS value
DRG-10754: memory size must be between string and string
ORA-16111: log mining and apply setting up
O2F-00309: Name of user-defined type is illegal or missing
NNL-00218: Ignoring spurious trailing text "string"
ORA-36990: (XSRELGID07) %a workspace object The level relation %1p should be dimensioned by a level dimension.
ORA-02020: too many database links in use
ORA-31194: Resource string is already deleted
ORA-25271: queue table not found for the given queue
ORA-01083: value of parameter "string" is inconsistent with that of other instances
Oracle Errors 
