Oracle Error ORA-22870: ALTER TYPE with REPLACE option a non-object type

Oracle Error Message

ORA-22870: ALTER TYPE with REPLACE option a non-object type

Reason for the Error

attempt to perform ALTER TYPE with REPLACE option a non-object type

Solution

drop the non-object type first, then re-create it as an object type