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-19578: end of volume while duplexing to sequential files, backup piece incomplete
ORA-14187: partitioning method for LOCAL index is inconsistent with that of the underlying table
TNS-12522: TNS:listener could not find available instance with given INSTANCE_ROLE
ORA-32331: type "string"."string" is incompatible with the master site
ORA-07492: scgrcl: cannot close lock.
ORA-12855: cannot run parallel or insert direct load in a loopback
ORA-36996: (XSRELGID13) Valueset workspace object should be defined over dimension workspace object.
TNS-12211: TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA
TNS-00545: parameter retrieval failure
ORA-12452: label tag string already exists
ORA-00303: cannot process Parallel Redo
RMAN-08039: channel string: starting incremental datafile backupset restore