Oracle DBA, How To, Error, Cause and Action

ORA-02262: ORA-string occurs while type-checking column default valueexpression

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




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




Action: Remove the default value expression or don't alter the column datatype.