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

TNS-01022: Alias string

1 Answers  


ORA-14523: Cannot co-locate [sub]partition of string string with table [sub]partition because string block size [string] does not match table block size [string]

1 Answers  


ORA-23307: replicated schema string already exists

1 Answers  


ORA-30340: illegal dimension name

1 Answers  


PLS-01420: INTERSECT and MINUS set operators are not ANSI

1 Answers  


TNS-00223: numbernumbernumbernumber

1 Answers  


ORA-16762: Invalid database state

1 Answers  


RMAN-06741: database name is "string" and DBID is string

1 Answers  


RMAN-06056: could not access datafile number

1 Answers  


QSM-02131: agg(expr) requires correspondng SUM(expr) function

1 Answers  


PLS-01910: : associative array shape is not consistent with session parameters

1 Answers  


ORA-39046: Metadata remap string has already been specified.

1 Answers  


Categories