QSM-02176: MV with UNION ALL in a view is too complex
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
Is This Answer Correct ? | 0 Yes | 0 No |
ORA-39308: application/database upgrade internal error: "string"
ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction
ORA-00321: log string of thread string, cannot update log file header
ORA-02155: invalid DEFAULT tablespace identifier
PLS-01413: Use of NULL an expression
ORA-13420: the SRID of the geometry parameter was not null
ORA-36740: A CHILDLOCK was detected in your valueset
ORA-38717: Invalid DUMP FLASHBACK option.
DRG-50859: failed to allocate statement handle
ORA-24375: Cannot use V6 syntax when talking to a V8 server
ORA-06548: no more rows needed
RMAN-06203: Changed KEEP options for string objects