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 |
ORA-25500: database is not open
ORA-16514: the request was not found
TNS-00239: Connection Manager has been stopped
ORA-13481: the destination type is not supported
LSX-00253: branch is empty
QSM-01058: MV, string, does not have column, string, for a joinback
NZE-28822: Required seed is not specified.
DRG-50100: CORE LSF error: string
NZE-29162: Non-FIPS cipher suites being used in FIPS mode.
ORA-16011: Archivelog Remote File Server process in Error state
PLS-00425: in SQL, function argument and return types must be SQL type
ORA-29866: cannot create domain index on a column of index-organized table