Oracle Error Message
ORA-32347: NULL capabilities during explain mview
Reason for the Error
The supplied defining query did not generate any capabilities information.
Solution
Replace the query since it is not suitable for creating a materialized view.