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

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

Oracle Error Message

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

Reason for the Error

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.

Solution

Restructure the materialized view query such that the respective sides of the UNION operator have identical select lists.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...