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 |
ORA-38454: attribute set not defined for the column being indexed
QSM-02151: subquery or named view in FROM list and < 9.0 compatibility
ORA-33304: (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.
ORA-13005: recursive HHCODE function error
PLS-00101: reserved for future use
LPX-00273: failed to initialize TCP/IP
ORA-16790: The value of the configurable property is invalid
TNS-00255: Closing down log, stopping Navigator
ORA-27071: unable to seek to desired position in file
KUP-04085: duplicate directory object string and file string specified for unload
ORA-28173: certificate not provided by proxy
RMAN-06001: error parsing job step library