Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02174: the materialized view does not have a UNION ALL
marker column
- 1 Answers
- 4833 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 |
ORA-39150: bad flashback time
ORA-09799: File label retrieval failed.
NNL-00532: set|show forwarding_available [<on|off>] [<server_list>] : enable, disable or show server request forwarding
SQL*Loader-00408: Physical record stack overflow
DRG-11601: URL store: bad syntax on request for string
TNS-12225: TNS:destination host unreachable
ORA-02836: Unable to create temporary key file
ORA-19809: limit exceeded for recovery files
ORA-07493: scgrcl: lock manager error.
ORA-31901: the current operation was cancelled by the user
ORA-22616: image is not of Oracle 8.1 format
ORA-36641: (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
Oracle Errors 
