Oracle Error ORA-32304: materialized views with user-defined types cannot use prebuilt table

Oracle Error Message

ORA-32304: materialized views with user-defined types cannot use prebuilt table

Reason for the Error

An attempt was made to create a materialized view with the ON PREBUILT TABLE option.

Solution

Do not create the materialized view with the ON PREBUILT TABLE option.