Answer / guest

Cause: If a materialized view has a view whose definition
involves a UNION ALL query, then the materialized view's
defining query cannot have any clauses other than SELECT or
FROM. Other clauses such as WHERE, HAVING, CONNECT BY, or
GROUP BY are not allowed. Further more, the FROM clause
should have only one item.

Action: Remove any clauses besides SELECT and FROM from the
materialized view's defining query.

Please add more information about this Error

EXP-00015: error on row number of table string, column string, datatype number

1 Answers  

---

ORA-25457: evaluation function string returns failure

1 Answers  

---

ORA-32021: parameter value longer than string characters

1 Answers  

---

ORA-02380: profile string does not exist

1 Answers  

---

ORA-09317: szprv: insufficient privileges

1 Answers  

---

ORA-28661: Object already has COMPRESS clause specified

1 Answers  

---

DRG-10602: failed to queue DML change to column string for primary key string

1 Answers  

---

ORA-10575: Give up restoring recovered datafiles to consistent state: out of memory

1 Answers  

---

RMAN-12005: error during channel cleanup

1 Answers  

---

ORA-02465: Inappropriate use of the HASH IS option

1 Answers  

---

LSX-00011: internal error: ~s

1 Answers  

---

NID-00139: Mismatched dbname for datafile string, expected string, found string

1 Answers  

---