QSM-02178: MV has a view with UNION ALL that is not fast
refreshable
- 1 Answers
- 2144 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The materialized view has a view whose definition
involves a UNION ALL query that does not satisfy the
requirements for fast refresh.
Action: Check that the defining query of the view being
referenced in the materialized view satisfies conditions for
fast refresh of a UNION ALL materialized view.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-36380: (AGGRECURSE) AGGREGATE was called recursively, which is not allowed.
LSX-00103: duplicate group "~S"
TNS-12685: Native service required remotely but disabled locally
NPL-00418: received malformed ASN.1 object identifier
TNS-01420: Presentation: string
ORA-29306: datafile string is not online
ORA-24344: success with compilation error
ORA-22975: cannot create a PRIMARY KEY-based REF to this object view
KUP-11002: unable to read data chunk string
ORA-06028: NETASY: unable to intialise for logging
PLS-01422: Aliases
DRG-50865: failed to append to collection
Oracle Errors 
