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-29544: invalid type

1 Answers  


TNS-04141: Unable to find CMAN.ORA file.

1 Answers  


ORA-06024: NETASY: VTM error

1 Answers  


SQL-02123: Context referenced in EXEC TOOLS GET CONTEXT statement not found

1 Answers  


IMG-00851: image data free failed

1 Answers  






ORA-37075: (XSMCSESS03) You cannot rename a session-only dimension value.

1 Answers  


ORA-02822: Invalid block offset

1 Answers  


IMG-00923: signature is empty

1 Answers  


TNS-12657: No algorithms installed

1 Answers  


RMAN-08181: media recovery complete, elapsed time: string

1 Answers  


ORA-31193: This versioning feature isn't supported for resource string

1 Answers  


ORA-31623: a job is not attached to this session via the specified handle

1 Answers  


Categories