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-13185: failed to generate initial HHCODE

1 Answers  


ORA-14299: total number of partitions/subpartitions exceeds the limit of 65535

1 Answers  


PLS-00140: duplicate external LIBRARY specification in subprogram expression

1 Answers  


ORA-00407: rolling upgrade from release string.string to string.string is not allowed

1 Answers  


ORA-31635: unable to establish job resource synchronization

1 Answers  






ORA-07508: scgfal: $deq all unexpected return

1 Answers  


ORA-29875: failed in the execution of the ODCIINDEXINSERT routine

1 Answers  


DRG-11518: text table string does not have a LONG or LONG RAW column

1 Answers  


TNS-12675: External user name not available yet

1 Answers  


ORA-27472: invalid metadata attribute string

1 Answers  


ORA-06004: NETASY: dialogue file open failure

1 Answers  


RMAN-06433: error installing recovery catalog

1 Answers  


Categories