QSM-02175: some query block in UNION ALL MV is not fast
refreshable
Answer / guest
Cause: For a materialized view with UNION ALL to be fast
refreshable, each query block must conform to a fast
refreshable materialized join view or materialized aggregate
view.
Action: Check each query block in the UNION ALL to ensure it
is either a materialized view with joins or aggregates.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
LSX-00166: both content types must be mixed or both must be element-only
ORA-36970: (XSRELTBL12) workspace object must be a self-relation.
AUD-00807: SpeechContains: index of indextype ORDSpeechIndex is required
ORA-22326: cannot change a type to FINAL if it has subtypes
IMG-00712: unable to write to destination image
PLS-00401: different column types between cursor SELECT statement and return value found at 'string'
PLS-00633: RETURN statement in a pipelined function cannot contain an expression
DRG-11711: too much data for term string
ORA-07823: sspsqr: $QIO failure
NCR-02006: NCRF: Invalid floating point representation received
TNS-01402: TYPE: string
ORA-19687: SPFILE not found in backup set