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-02170: tables must be identical across the UNION operator



QSM-02170: tables must be identical across the UNION operator..

Answer / guest

Cause: You have specified a materialized view using the
UNION operator and the tables on each side of the UNION
operator do not match. Fast refresh is not supported in this
context.

Action: Restructure the materialized view query such that
the respective sides of the UNION operator have the same table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23442: object already exists for the refresh group template

1 Answers  


ORA-32400: cannot use object id columns from materialized view log on "string"."string"

1 Answers  


NMP-00010: memory exhausted

1 Answers  


ORA-38499: expression set already configured for stored/indexed attributes

1 Answers  


ORA-02056: 2PC: string: bad two-phase command number string from string

1 Answers  


ORA-23452: flavor string of object group "string"."string" is already published

1 Answers  


PLS-00204: function or pseudo-column 'string' may be used inside a SQL statement only

1 Answers  


TNS-00102: Keyword-Value binding operation error

1 Answers  


ORA-02069: global_names parameter must be set to TRUE for this operation

1 Answers  


ORA-13704: Invalid value "string" specified for parameter "string".

1 Answers  


ORA-06106: NETTCP: socket creation failure

1 Answers  


ORA-12169: TNS:Net service name given as connect identifier is too long

1 Answers   Reliance, Satyam,


Categories