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-38454: attribute set not defined for the column being indexed

1 Answers  


QSM-02151: subquery or named view in FROM list and < 9.0 compatibility

1 Answers  


ORA-33304: (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.

1 Answers  


ORA-13005: recursive HHCODE function error

1 Answers  


PLS-00101: reserved for future use

1 Answers  


LPX-00273: failed to initialize TCP/IP

1 Answers  


ORA-16790: The value of the configurable property is invalid

1 Answers  


TNS-00255: Closing down log, stopping Navigator

1 Answers  


ORA-27071: unable to seek to desired position in file

1 Answers  


KUP-04085: duplicate directory object string and file string specified for unload

1 Answers  


ORA-28173: certificate not provided by proxy

1 Answers  


RMAN-06001: error parsing job step library

1 Answers  


Categories