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


QSM-02177: MV with UNION ALL in a view must match the view's
SELECT list



QSM-02177: MV with UNION ALL in a view must match the view's SELECT list..

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01079: ORACLE database was not properly created, operation aborted

1 Answers  


DRG-11216: length of datastore data exceeds limit

1 Answers  


DRG-12229: special section string already exists in this section group

1 Answers  


ORA-31438: duplicate change table string

1 Answers  


DRG-11818: Temporary Redirect

1 Answers  






ORA-26522: rpc execution error

1 Answers  


ORA-25229: error on transformation of message string string

1 Answers  


TNS-12680: Native services disabled but required

1 Answers  


ORA-01604: illegal number range in clause "string" of string

1 Answers  


ORA-39705: component 'string' not found in registry

1 Answers  


O2U-00210: Unable to allocate memory

1 Answers  


ORA-02287: sequence number not allowed here

1 Answers  






Categories