QSM-02150: select lists must be identical across the UNION
operator



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

Post New Answer

More Oracle Errors Interview Questions

UDE-00014: invalid value for parameter, 'string'.

1 Answers  


SQL*Loader-00956: Error calling once/data file finishing

1 Answers   Wipro,


ORA-33462: (ESDREAD10A) Discarding compiled code for workspace object because object number is not in analytic workspace string.

1 Answers  


LPX-00107: element "~S" has multiple declarations

1 Answers  


LPX-00258: invalid "Mixed" specification in element declaration

1 Answers  






LPX-00106: attribute "~1S" of element "~2S" is undefined

1 Answers  


LPX-00231: invalid character ~1u ('~2c') found in a Name or Nmtoken

1 Answers  


ORA-04065: not executed, altered or dropped string

1 Answers  


ORA-06921: CMX: getdatmsg illegal datatype

1 Answers  


EXP-00057: Failure to initialize parameter manager

1 Answers  


ORA-16186: Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier

1 Answers  


LPX-00268: invalid access method ~1d, must be 0 to ~2d

1 Answers  


Categories