Oracle Error Message
ORA-32311: materialized view definition query selects an unsupported user-defined type
Reason for the Error
An attempt was made in the definition query to select an embedded user-defined type, function returning a user-defined type, or a function whose arguments are user-defined types.
Solution
Rewrite the definition query to exclude these unsupported user-defined types.