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-02178: MV has a view with UNION ALL that is not fast
refreshable



QSM-02178: MV has a view with UNION ALL that is not fast refreshable..

Answer / guest

Cause: The materialized view has a view whose definition
involves a UNION ALL query that does not satisfy the
requirements for fast refresh.

Action: Check that the defining query of the view being
referenced in the materialized view satisfies conditions for
fast refresh of a UNION ALL 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-25134: keyword TABLE expected

1 Answers  


ORA-30395: dimension options require the COMPATIBLE parameter to be string or greater

1 Answers  


ORA-19699: cannot make copies with compression enabled

1 Answers  


ORA-24311: memory initialization failed

1 Answers  


ORA-25014: cannot change the value of a PARENT reference variable

1 Answers  


LPX-00018: internal error "nested open strings"

1 Answers  


ORA-22345: recompile type string.string before attempting this operation

1 Answers  


EXP-00023: must be a DBA to do Full Database or Tablespace export

1 Answers  


PCC-00129: Option "string" must be given

1 Answers  


DRG-12440: document table read failed

1 Answers  


TNS-12673: Dedicated server: context not saved

1 Answers  


QSM-02091: mv references a non-repeatable or session-sensitive expression

1 Answers  


Categories