Answer / guest

Cause: The capability in question is not supported when the
materialized view uses an aggregate expression in the HAVING
clause.

Action: Re-phrase the query to avoid the use of an aggregate
in the HAVING clause.

Please add more information about this Error

ORA-31429: subscription has not been activated

1 Answers  

---

ORA-25148: ONLINE option not permitted

1 Answers  

---

ORA-29358: resource plan string does not exist

1 Answers  

---

ORA-24044: source string and destination string object types do not match

1 Answers  

---

ORA-02285: duplicate START WITH specifications

1 Answers  

---

ORA-31452: invalid value string for parameter, expecting: Y or N

1 Answers  

---

O2U-00200: Internal error in OTT facility O2U

1 Answers  

---

ORA-34358: (MXDSS14) number other users reading

1 Answers  

---

ORA-12021: materialized view "string"."string" is corrupt

1 Answers  

---

LSX-00230: invalid integer "~S"

1 Answers  

---

ORA-30489: Cannot have more than one rollup/cube expression list

1 Answers  

---

DRG-10849: catsearch does not support functional invocation

1 Answers  

---