ORA-12013: updatable materialized views must be simple
enough to do fast refresh
- 1 Answers
- 4890 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 |
NNL-00217: Controller is sleeping for number seconds
ORA-03281: invalid ALLOCATE EXTENT option
ORA-01627: rollback segment number 'string' is not online
ORA-19647: non-zero LEVEL cannot be specified when INCREMENTAL is FALSE
ORA-06732: TLI Driver: cannot alloc t_discon
TNS-01048: No changes to save for string.
ORA-08444: syntax error in JUSTIFIED clause in mask options
ORA-36202: (XSAGOP01) 'number' is not a valid aggregation operator.
NZE-28840: Wallet is already open.
DRG-10101: no value for argument: string
ORA-14291: cannot EXCHANGE a composite partition with a non-partitioned table
ORA-16593: XML conversion failed
Oracle Errors 
