Oracle Error ORA-22330: cannot alter a type that is not valid

Oracle Error Message

ORA-22330: cannot alter a type that is not valid

Reason for the Error

An attempt was made to perform ALTER TYPE on an invalid type.

Solution

Use the CREATE OR REPLACE TYPE command to modify the type.