Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

CLSS-00101: Oracle Cluster Repository mismatch with node string. (string != string)

1 Answers  


ORA-28579: network error during callback from external procedure agent

1 Answers  


ORA-02803: Retrieval of current time failed

1 Answers  


IMG-00840: image structure allocation failed

1 Answers  


ORA-24811: less data provided for writing than indicated

1 Answers  






ORA-14021: MAXVALUE must be specified for all columns

1 Answers  


ORA-25226: dequeue failed, queue string.string is not enabled for dequeue

1 Answers  


RMAN-01008: the bad identifier was: string

1 Answers  


ORA-02305: only EXECUTE, DEBUG, and UNDER privileges are valid for types

1 Answers  


VID-00703: unable to read video data

1 Answers  


ORA-29822: selectivity cannot be specified for the type of object

1 Answers  


DRG-11715: attempt to add a BT relation between 2 KB categories string and string

1 Answers  






Categories