QSM-02091: mv references a non-repeatable or
session-sensitive expression



QSM-02091: mv references a non-repeatable or session-sensitive expression..

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

Post New Answer

More Oracle Errors Interview Questions

RMAN-06165: datafile string is too old to recover, restore a more recent copy

1 Answers  


ORA-15033: disk 'string' belongs to diskgroup "string"

1 Answers  


ORA-39017: Worker request not supported when job is in string state.

1 Answers  


ORA-19662: archived log thread string sequence string could not be verified

1 Answers  


PROC-00005: User does not have permission to perform a cluster registry operation on this key.

1 Answers  






ORA-22923: amount of data specified in streaming LOB write is 0

1 Answers  


ORA-39302: schema clone operation failed

1 Answers  


ORA-15030: diskgroup name "string" is in use by another diskgroup

1 Answers  


ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices

1 Answers  


ORA-12591: TNS:event signal failure

1 Answers  


ORA-16080: invalid LogMiner session string for APPLY

1 Answers  


RMAN-12008: could not locate backup piece string

1 Answers  


Categories