materialized views

[carlose]

Is it possible to create a mv from another mv for update? The first mv is a "refresh complete" since it contains a complex query w an outer join and the second mv is "for update" where I select * from first mv. Is this even possibe? I get the classic:

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


Thanks in advance - carlos

[debasisdas]

The error message is self explanatory.