QSM-02091: mv references a non-repeatable or
session-sensitive expression
- 1 Answers
- 3279 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The capability in question is not supported when the
materialized view uses an expression that may not return the
same value each time it is invoked against the same set of
rows or that may return different values depending on
session parameters.
Action: Re-phrase the query to avoid the use of such
expressions.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-14610: Lob attributes not specified for lob column string for subpartition string
ORA-36393: (XSMXCLEA03) When using the CHANGES or CACHE options, you must specify the ALL keyword.
ORA-30477: The input select_clause is incorrectly specified
ORA-03218: invalid option for CREATE/ALTER TABLESPACE
ORA-09959: IMON: deletion of a process failed.
PLS-00351: Not logged onto database 'string'
RMAN-06529: CHANGE ... KEEP not supported for ARCHIVELOG
ORA-13211: failed to tessellate the window object
ORA-02373: Error parsing insert statement for table string.
ORA-30163: The thread safety initialization failed
ORA-31122: The string operator has incorrect RHS value
ORA-24325: this OCI operation is not currently allowed
Oracle Errors 
