QSM-02176: MV with UNION ALL in a view is too complex



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

Post New Answer

More Oracle Errors Interview Questions

ORA-39308: application/database upgrade internal error: "string"

1 Answers  


ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction

1 Answers  


ORA-00321: log string of thread string, cannot update log file header

1 Answers  


ORA-02155: invalid DEFAULT tablespace identifier

2 Answers  


PLS-01413: Use of NULL an expression

1 Answers  






ORA-13420: the SRID of the geometry parameter was not null

1 Answers  


ORA-36740: A CHILDLOCK was detected in your valueset

1 Answers  


ORA-38717: Invalid DUMP FLASHBACK option.

1 Answers  


DRG-50859: failed to allocate statement handle

1 Answers  


ORA-24375: Cannot use V6 syntax when talking to a V8 server

1 Answers  


ORA-06548: no more rows needed

1 Answers  


RMAN-06203: Changed KEEP options for string objects

1 Answers  


Categories