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

ORA-01867: the interval is invalid

1 Answers  

---

ORA-00311: cannot read header from archived log

1 Answers  

---

ORA-29865: indextype is invalid

1 Answers  

---

NZE-29111: Invalid index

1 Answers  

---

PLS-00367: a RAISE statement with no exception name must be inside an exception handler

1 Answers  

---

ORA-15023: reached maximum allowable number of disks string

1 Answers  

---

ORA-25351: transaction is currently in use

1 Answers  

---

ORA-29376: number of consumer groups string in top-plan string exceeds string

1 Answers  

---

ORA-24321: inconsistent parameters passed

1 Answers  

---

ORA-25531: MTTR specified is too small: string

1 Answers  

---

TNS-12212: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  

---

ORA-30939: Order violation: Element 'string' may not follow element 'string'

1 Answers  

---