Materialized View Becomes Invalid After Recompiling

Workaround:

 alter session set "_connect_by_use_union_all" = false;

Now recompile the mviews