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


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-31113: XDB configuration may not be updated with non-schema compliant data

1 Answers  


SQL*Loader-00118: Invalid parallel load option

1 Answers  


ORA-14303: partitions or subpartitions are not in the right order

1 Answers  


ORA-23490: extension request "string" with status "string" not allowed in this operation

1 Answers  


ORA-00132: syntax error or unresolved network name 'string'

1 Answers  






O2I-00111: Unable to allocate memory

2 Answers  


ORA-32503: Mapping SGA from file failed

1 Answers  


ORA-12023: missing index on materialized view "string"."string"

1 Answers  


PCC-01513: FIPS warning: Unsupported datatype in line number of file string

1 Answers  


NNL-00807: Queries received, type SOA: number

1 Answers  


ORA-00223: convert file is invalid or incorrect version

1 Answers  


ORA-29380: resource plan string is currently active and cannot be deleted

1 Answers  






Categories