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
- 4841 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-16139: media recovery required
ORA-02091: transaction rolled back
TNS-00542: SSL Handshake failed
NZE-29227: Certificate is expired.
ORA-29335: tablespace 'string' is not read only
ORA-13149: failed to generate next sequence number for spatial table string
ORA-12540: TNS:internal limit restriction exceeded
ORA-08210: Requested I/O error
DRG-12307: column string is NULL and cannot be indexed
ORA-16778: log transport error for one or more databases
DRG-50937: query too complex
ORA-30354: Query rewrite not allowed on SYS relations
Oracle Errors 
