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-06563: top level procedure/function specified, cannot have subparts
ORA-30006: resource busy; acquire with WAIT timeout expired
ORA-37072: (XSMCSESS00) Object workspace object has the wrong type.
ORA-09790: sllfcf: unable to close file.
ORA-13616: The current user string has not been granted the ADVISOR privilege.
ORA-24096: invalid message state specified
ORA-29881: failed to validate indextype
ORA-31103: Resource locked in shared mode. Cannot add exclusive lock
PCC-02349: precision must be specified for this type
ORA-27211: Failed to load Media Management Library
RMAN-01008: the bad identifier was: string
PCC-02420: Incomplete (or missing) type specification