ORA-12013: updatable materialized views must be simple
enough to do fast refresh



ORA-12013: updatable materialized views must be simple enough to do fast refresh..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-36772: (XSPGERRTEMP) Ran out of temporary storage while writing to analytic workspace with ID=number. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.

1 Answers  


ORA-21710: argument is expecting a valid memory address of an object

1 Answers  


TNS-01160: Trace level was not specified

1 Answers  


ORA-16146: standby destination control file enqueue unavailable

1 Answers  


DRG-50924: PL/SQL inside PL/SQL not supported

1 Answers  






IMG-00602: unable to access image data

1 Answers  


ORA-31039: XML namespace length string exceeds maximum string

1 Answers  


TNS-04206: Trace Assistant Internal ERROR: Packet Type

1 Answers  


ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

1 Answers  


ORA-19627: cannot read backup pieces during controlfile application

1 Answers  


QSM-00513: one or more of the workload tables is missing

1 Answers  


ORA-09959: IMON: deletion of a process failed.

1 Answers  


Categories