Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-09825: Unable to disable allowmacaccess privilege.

1 Answers  


ORA-29295: invalid mime header tag

1 Answers  


TNS-02521: encryption/crypto-checksumming: Diffie-Hellman seed too small

1 Answers  


SQL*Loader-00290: PIECED keyword (on column string) allowed only for lob or long columns

1 Answers  


ORA-19587: error occurred reading string bytes at block number string

1 Answers  






ORA-01166: file number string is larger than string (string)

1 Answers  


NNO-00617: enabling AUTHORITY-REQUIRED on system queries

1 Answers  


ORA-40204: model string already exists

1 Answers  


ORA-31626: job does not exist

1 Answers  


ORA-12051: ON COMMIT attribute is incompatible with other options

1 Answers  


ORA-06254: NETNTT: cannot share connection to cube

1 Answers  


ORA-25952: join index must only contain inner equi-joins

1 Answers  






Categories