Oracle Error ORA-02262: ORA-string occurs while type-checking column default value expression

Oracle Error Message

ORA-02262: ORA-string occurs while type-checking column default value expression

Reason for the Error

New column datatype causes type-checking error for existing column default value expression.

Solution

Remove the default value expression or don’t alter the column datatype.