Oracle : Ошибка ORA-12013

"updatable materialized views must be simple enough to do fast refresh"
*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

Попробовать перевести

Поискать эту ошибку на форуме