QSM-02037: cannot evaluate constant expression at compile time
Answer / guest
Cause: The capability in question is not supported when the
materialized view uses a compile-time non-constant
expression in a filter condition in the WHERE or HAVING
clauses. For example, WHERE X=1 uses a compile-time constant
expression in a filter condition. WHERE
X=MY_PLSQL_FUNCTION() uses a compile-time non-constant
expression in a filter condition.
Action: Re-phrase the query to avoid the use of a
compile-time non-constant expressions in filter conditions.
Please add more information about this Error
|Is This Answer Correct ?||0 Yes||0 No|
NNO-00330: server saved the config file "string".
ORA-02069: global_names parameter must be set to TRUE for this operation
LPX-00241: entity reference is not well formed
LSX-00250: invalid normalizedString "~S"
ORA-24302: host connection in use by another thread
ORA-16014: log string sequence# string not archived, no available destinations
SQL*Loader-00909: Loader views must be loaded (as SYS) for direct path to be used
ORA-22345: recompile type string.string before attempting this operation
RMAN-20039: format requires character when duplexing
ORA-00407: rolling upgrade from release string.string to string.string is not allowed
ORA-30741: WITH HIERARCHY OPTION can be specified only for SELECT privilege
ORA-12404: invalid privilege string: string