Oracle Error Codes

cannot decrease column length because some value is too big

An ALTER TABLE MODIFY statement attempted to decrease the size of a character field containing data. A column whose maximum size is to be decreased must contain only NULL values.

How to Solve :

Set all values in column to NULL before decreasing the maximum size.