QSM-02150: select lists must be identical across the UNION
operator
Answer / guest
Cause: You have specified a materialized view using the
UNION operator and the respective queries on each side of
the UNION operator do not have the same select list. The
RELATED_NAME column shows the alias of the first different
select list item. The RELATED_NUM column shows the offset
from the SELECT keyword to the start of this select list item.
Action: Restructure the materialized view query such that
the respective sides of the UNION operator have identical
select lists.
Please add more information about this Error
Is This Answer Correct ? | 0 Yes | 0 No |
NNL-00575: list_objects: list all objects in a domain or subtree
ORA-27093: could not delete directory
SQL-02149: ANSI Dynamic insufficient item descriptor areas
ORA-25187: specified exceptions table form incorrect
ORA-31642: the following SQL statement fails: string
ORA-29286: internal error
PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification
ORA-01683: unable to extend index string.string partition string by string in tablespace string
ORA-02474: Fixed hash area extents used (string) exceeds maximum allowed (string)
LSX-00163: duplicated content specification in "~S"
RMAN-06581: option string not supported
ORA-09271: szlon: error verifying user name