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

ORA-25140: %s space policy cannot be specified for the string extent management

1 Answers  

---

ORA-14079: illegal option for a partition marked Index Unusable

1 Answers  

---

ORA-00311: cannot read header from archived log

1 Answers  

---

NPL-00102: missing stream functions in ASN.1 context initialization

1 Answers  

---

SQL*Loader-00709: Internal error calling SLTS layer: string failed

1 Answers  

---

TNS-00293: Trace File Name : string

1 Answers  

---

ORA-13900: missing or invalid parameter string

1 Answers  

---

ORA-02478: merge into base segment would overflow MAXEXTENTS limit

1 Answers  

---

ORA-09853: snyRemovePort: bad return code from request.

1 Answers  

---

ORA-39020: invalid mode type string

1 Answers  

---

ORA-07596: sptpa: $GETJPIW failure

1 Answers  

---

ORA-00321: log string of thread string, cannot update log file header

1 Answers  

---