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-26563: renaming this table is not allowed

1 Answers  


AMD-00132: dimension #string: RDBMS GID column data type not specified

1 Answers  


ORA-16635: NetSlave connection was broken in the middle of a transmission session.

1 Answers  


QSM-01131: query has ONLY_MULTIMV_REWRITE hint

1 Answers  


DRG-51023: stemmer file cannot be opened

1 Answers  






NZE-28808: Cannot retrieve method information from the configuration file.

1 Answers  


ORA-30749: column string not enabled to store objects of type string.string

1 Answers  


ORA-12615: TNS:preempt error

1 Answers  


ORA-29826: keyword FOR is missing

1 Answers  


RMAN-00566: could not open TRACE "string"

1 Answers  


TNS-04049: Specified connections do not exist

1 Answers  


NNO-00062: cannot load domain data from configuration database

1 Answers  


Categories