Answer / guest

Cause: For a materialized view with UNION ALL to be fast
refreshable, it must have a UNION ALL marker column. This is
a constant column, at the same ordinal position in each
query block and must have distinct values in each query block.

Action: Add a UNION ALL marker column to each query block in
the UNION ALL query defining the materialized view.

Please add more information about this Error

ORA-00317: file type string in header is not log file

1 Answers  

---

ORA-02315: incorrect number of arguments for default constructor

1 Answers  

---

ORA-31404: all input parameters are null

1 Answers  

---

RMAN-06143: LIKE may only be specified with COPY

1 Answers  

---

AMD-00115: PROCEDURE string, invalid file handle

1 Answers  

---

ORA-25501: ALTER SYSTEM QUIESCE RESTRICTED command failed

1 Answers  

---

DRG-11719: Broader Term hierarchy too deep

1 Answers  

---

TNS-00103: Parameter file load error

1 Answers  

---

ORA-16733: Error executing dbms_logstdby.unskip procedure

1 Answers  

---

Why we can't perform DML operations on Materialized views???

1 Answers   CGI,

---

ORA-16527: unable to allocate SGA heap

1 Answers  

---

CLSS-03200: timed out waiting on nested reconfiguration

1 Answers  

---