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

NNL-00264: Request forwarding is now disabled

1 Answers  


LSX-00168: referring form of "~S" must NOT occur at the top level

1 Answers  


QSM-01107: Partition Containment Tracking (PCT) rewrite is not allowed

1 Answers  


LFI-01509: fopen() failed(OSD return value = string).

1 Answers  


RMAN-06545: "string" is an invalid response - please re-enter.

1 Answers  






ORA-25401: can not continue fetches

1 Answers  


PLS-00308: this construct is not allowed as the origin of an assignment

1 Answers  


ORA-24397: error occured while trying to free connections

1 Answers  


SQL*Loader-00477: REF directive for field string requires at least two arguments

1 Answers  


NNO-00303: server "string" started with process ID number

1 Answers  


ORA-12545: Connect failed because target host or object does not exist

1 Answers  


DRG-11801: Continue

1 Answers  


Categories