Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

ORA-02404: specified plan table not found

2 Answers  


ORA-02814: Unable to get shared memory

1 Answers  


RMAN-06204: Changed string objects to UNAVAILABLE status

1 Answers  


ORA-01876: year must be at least -4713

1 Answers  


ORA-24395: cannot reinitialize non-existent pool

1 Answers  


RMAN-07513: List of Files Which Where Not Cataloged

1 Answers  


ORA-30082: datetime/interval column to be modified must be empty to decrease fractional second or leading field precision

1 Answers  


ORA-31450: invalid value for change_table_name

1 Answers  


ORA-01294: error occurred while processing information in dictionary file string, possible corruption

2 Answers  


ORA-13903: Invalid combination of string threshold value and operator.

1 Answers  


PLS-00216: NUMBER precision constraint must be in range (1 .. 38)

1 Answers  


ORA-28179: client user name not provided by proxy

1 Answers  


Categories