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

TNS-00269: OFF

1 Answers  

---

PLS-00116: Duplicate where-clause in table expression

1 Answers  

---

ORA-29847: cannot create a local domain index on a partitioned index-organized table

1 Answers  

---

RMAN-06416: PROXY ONLY was specified and some files could not be proxy copied

1 Answers  

---

ORA-03202: the scan limit specification is invalid

1 Answers  

---

RMAN-03033: current log archived

1 Answers  

---

PLS-01911: : associative array key violates its type constraints

1 Answers  

---

SQL-02113: Unable to open message file

1 Answers  

---

ORA-09273: szrfc: error verifying role name

1 Answers  

---

ORA-36698: (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.

1 Answers  

---

ORA-01223: RESETLOGS must be specified to set a new database name

1 Answers  

---

ORA-30437: all job queue processes have stopped running

1 Answers  

---