ORA-12013: updatable materialized views must be simple
enough to do fast refresh
- 1 Answers
- 5182 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 |
ORA-28116: insufficient privileges to do direct path access
RMAN-06411: backup copies setting out of range (1-4): number
QSM-01049: semi-join check failed for materialized view, string
ORA-08311: sllfop: bad value for maxrecsize
ORA-13523: unable to allocate required space for return type
ORA-32312: cannot refresh a secondary materialized view "string"."string"
ORA-09320: szrfc: unable to obtain the list of valid OS roles
ORA-16506: out of memory
ORA-12411: invalid label value
ORA-12995: no columns in partially dropped state
ORA-14153: only one of STORE IN or <partition-description> clause may be specified
ORA-01763: update or delete involves outer joined table
Oracle Errors 
