ORA-12013: updatable materialized views must be simple
enough to do fast refresh
- 1 Answers
- 4888 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The updatable materialized view query contained a
join, subquery, union, connect by, order by, or group by caluse.
Action: Make the materialized view simpler. If a join is
really needed, make multiple simple materialized views then
put a view on top of them.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
DRG-12233: xml sections cannot co-exist with other section types
TNS-04081: Event groups:
ORA-31105: User does not own lock "string"
ORA-13185: failed to generate initial HHCODE
ORA-10617: Cannot create rollback segment in dictionary managed tablespace
ORA-22610: error while adding a scalar to the image handle
PCC-02100: Unable to initialize PL/SQL
PCC-02389: Arrays not allowed as input bind variables in SELECT list
ORA-14062: one or more of table's partitions reside in a read-only tablespace
ORA-16642: db_unique_name mismatch
ORA-31640: unable to open dump file "string" for read
ORA-34350: (MXDSS06) string is an open analytic workspace.
Oracle Errors 
