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-24376: cannot register/get user callback for non-environment handle

1 Answers  


QSM-00784: the string string referenced in the list string is invalid for parameter string

1 Answers  


ORA-23365: site string does not exist

1 Answers  


ORA-30509: client logoff triggers cannot have AFTER type

1 Answers  


ORA-39052: cannot specify SKIP_CURRENT on initial start of a job.

1 Answers  


RMAN-06499: skipping archive log file string; already backed up string time(s)

1 Answers  


ORA-32128: setDataBuffer called after fetch has started

1 Answers  


NZE-29235: the key information could not be retrieved

1 Answers  


RMAN-06078: the controlfile is older than datafile string

1 Answers  


ORA-00350: log string of instance string (thread string) needs to be archived

1 Answers  


PLS-00624: USING clause must be used with either aggregate or pipelined functions

1 Answers  


TNS-01113: save_config_on_stop can either be ON or OFF

1 Answers  


Categories