Answer / guest

Cause: If a materialized view has a view whose definition
involves a UNION ALL query, then the materialized view's
select list must match the underlying view's select list
exactly. It must not have any expressions and must not have
add/drop/reorder columns from the underlying view.

Action: Use select * when defining a materialized view with
a UNION ALL in a view.

Please add more information about this Error

SQL*Loader-00293: Missing XMLTYPE directive in control file for table string

1 Answers  

---

ORA-04022: nowait requested, but had to wait to lock dictionary object

2 Answers   Oracle,

---

PLS-00245: Formals used in the 'parameters' clause must appear exactly once

1 Answers  

---

ORA-02440: Create as select with referential constraints not allowed

1 Answers  

---

ORA-23412: master table's primary key columns have changed

1 Answers  

---

DRG-11005: invalid create index parameter string

1 Answers  

---

PLS-00632: NOT INSTANTIABLE method cannot have a body

1 Answers  

---

PLS-00118: Duplicate group-by clause in table expression

1 Answers  

---

ORA-07843: sllfcl: LIB$FREE_VM failure

1 Answers  

---

ORA-28001: the password has expired

1 Answers  

---

ORA-13283: failure to get new geometry object for conversion in place

1 Answers  

---

RMAN-03030: echo set off

1 Answers  

---