Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

SQL*Loader-00286: ROWS parameter is not supported when loading an IOT.

1 Answers  


ORA-22974: missing WITH OBJECT OID clause

1 Answers  


RMAN-07502: List of Files Unknown to the Database

1 Answers  


RMAN-05502: the target database must be mounted when issuing a DUPLICATE command

1 Answers  


ORA-16061: Log file status has changed

1 Answers  






LFI-00142: Unable to delete an existing file [string][string] not owned by Oracle.

1 Answers  


ORA-30101: unknown parameter name 'string'

1 Answers  


DRG-10754: memory size must be between string and string

1 Answers  


ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change

1 Answers  


PCC-01010: Invalid use of NULL character in character literal

1 Answers  


ORA-02239: there are objects which reference this sequence

1 Answers  


RMAN-10012: KGU error: string

1 Answers  






Categories