QSM-02174: the materialized view does not have a UNION ALL
marker column
- 1 Answers
- 4341 Views
- I also Faced
- E-Mail Answers
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 |
DRG-11533: improper value of column string
ORA-38770: FLASHBACK DATABASE failed during recovery.
PLS-00752: Table function string is in an inconsistent state.
NNL-00873: Fastest update processing time: string
ORA-28233: double encryption not supported
ORA-01482: unsupported character set
ORA-14644: table is not subpartitioned by Hash method
ORA-39136: cannot specify an SCN on a transportable job
DRG-11835: Requested Range Not Satisfiable
ORA-19009: Missing XMLSchema keyword
ORA-13220: failed to compare tile with the geometry
DRG-12007: You might not be allowed to use this method here, continue?
Oracle Errors 
