Oracle Error Message
ORA-32308: object materialized views must use SELECT *
Reason for the Error
An attempt was made to create an object materialized view where the definition query did not use SELECT * at the topmost level.
Solution
Rewrite the definition query so that SELECT * is used at the topmost level.