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-02174: the materialized view does not have a UNION ALL
marker column



QSM-02174: the materialized view does not have a UNION ALL marker column..

Answer / guest

Cause: For a materialized view with UNION ALL to be fast
refreshable, it must have a UNION ALL marker column. This is
a constant column, at the same ordinal position in each
query block and must have distinct values in each query block.

Action: Add a UNION ALL marker column to each query block in
the UNION ALL query defining the materialized view.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-39752: redundent column in partitioning and join columns is not allowed

1 Answers  


NNL-00902: ALIAS LOOP responses sent: number

1 Answers  


TNS-00219: Pump Strategy : string

1 Answers  


ORA-25265: specified signature for a queue which does not support reciever non-repudiation

1 Answers  


ORA-31444: parameter error while acquiring lock on string

1 Answers  


ORA-16001: database already open for read-only access by another instance

1 Answers  


PLS-01425: Connect-by clause

1 Answers  


LPX-00105: element "~S" is not empty as required by the DTD

1 Answers  


RMAN-20032: checkpoint change# too low

1 Answers  


KUP-04005: file operation successful

1 Answers  


LSX-00144: attribute "~1S" invalid derivation-restriction value "~2S"

1 Answers  


DRG-12437: highlight table release failed

1 Answers  


Categories