Answer / guest

Cause: For a materialized view with UNION ALL to be fast
refreshable, each query block must conform to a fast
refreshable materialized join view or materialized aggregate
view.

Action: Check each query block in the UNION ALL to ensure it
is either a materialized view with joins or aggregates.

Please add more information about this Error

ORA-31092: invalid SQL name "string"

1 Answers  

---

SQL-02123: Context referenced in EXEC TOOLS GET CONTEXT statement not found

1 Answers  

---

ORA-02263: need to specify the datatype for this column

1 Answers  

---

ORA-25197: an overflow segment already exists for the indexed-organized table

1 Answers  

---

NNL-00562: unregister <name> [-d<address>] [-l<listener_name>] : unregister an object with Oracle Names

1 Answers  

---

IMG-00530: internal error while parsing command

1 Answers  

---

QSM-02049: subquery using the ANY clause in mv

1 Answers  

---

ORA-07509: scgfal: $deq parent lock unexpected return

1 Answers  

---

PCB-00101: Could not find or open system configuration file

1 Answers  

---

ORA-12033: cannot use filter columns from materialized view log on "string"."string"

1 Answers  

---

ORA-19016: attributes cannot occur after element specifications

1 Answers  

---

ORA-03124: two-task internal error

1 Answers  

---