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 |
ORA-32579: password for SYSTEM already specified
NNC-00501: warning: "string" parameter value must be between number and number, setting to number
RMAN-08100: channel string: starting proxy validation
NZE-28822: Required seed is not specified.
PLS-01418: Subquery cannot include set operators in ANSI's grammar
ORA-16579: bad Data Guard NetSlave state detected
SQL*Loader-00562: record too big
ORA-29906: indextype string.string does not exist
RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE command
ORA-09988: error while detaching SGA
DRG-11440: operation not supported for the string language
ORA-28112: failed to execute policy function