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

DRG-12227: a zone section named string already exists in this section group

1 Answers  


KUP-03002: end position (number) <= start position (number) for field: string

1 Answers  


RMAN-08126: keep attributes for the proxy copy are changed

1 Answers  


ORA-24184: transformation string.string, already exists

1 Answers  


ORA-07759: slemtr: invalid destination

1 Answers  






ORA-01920: user name 'string' conflicts with another user or role name

1 Answers  


ORA-06404: NETCMN: invalid login (connect) string

1 Answers  


LFI-01503: Max filename size exceeded generating filename.

1 Answers  


DRG-11608: URL store: host portion of string specified incorrectly

1 Answers  


RMAN-06487: changed proxy copy expired

1 Answers  


ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index

1 Answers  


ORA-08000: maximum number of session sequence lists exceeded

1 Answers  


Categories