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-09918: Unable to get user privileges from SQL*Net

1 Answers  

---

PCC-02207: Invalid macro name

1 Answers  

---

ORA-38603: FI including & excluding cursor can only return one column

1 Answers  

---

IMG-00803: invalid attribute value

1 Answers  

---

ORA-27504: IPC error creating OSD context

1 Answers  

---

---

LFI-01507: fwrite() failed(OSD return value = string) in string.

1 Answers  

---

ORA-14042: partition bound may not be specified for a partition being moved, modified or rebuilt

1 Answers  

---

ORA-30731: scope constraint not allowed on nested table column when the nested table is being created

1 Answers  

---

ORA-10921: Cannot drop tablespace belonging to default temporary tablespace group

1 Answers  

---

NZE-29246: the toolkit could not parse the tdu

1 Answers  

---

ORA-08260: ora_addr: cannot open nameserver

1 Answers  

---

ORA-38708: not enough space for first flashback database log file

2 Answers  

---