Description:
ORA-01440 column to be modified must be empty to decrease precision or scale
Cause:
An ALTER TABLE MODIFY statement attempted to decrease the scale or precision of a numeric column containing data. In order to decrease either of these values, the column must contain only NULL values. An attempt to increase the scale without also increasing the precision will also cause this message.
ORA-00900 to ORA-01499 lrm-00118: syntax error at '=' at the end of input, ora -2571, ora 01440 workaround, ora-01440, ora-01440 modified increase, ora-01440 solution, ora-01440: column to be modified, ora-01440: column to be modified must be empty to decrease precision or scale, ora-01440: column to be modified must be empty to decrease precision or scale workaround, ora-01440: column to be modified must be empty to decrease precision or scale01440. 00000 - "column to be modified must be empty to decrease precision or scale", ora01440, oracle sql error: ora-01440: column to be modified must be empty to decrease precision or scale 01440. 00000 - "column to be modified must be empty to decrease precision or scale", remedy ora_01440, remedy upgrade ora-01440, solution for ora-01440, sql error: ora-01440, sql error: ora-01440: column to be modified must be empty to decrease precision or scale, sql error: ora-01440: column to be modified must be empty to decrease precision or scale 01440. 00000 - "column to be modified must be empty to decrease precision or scale", sql error: ora-01440: column to be modified must be empty to decrease precision or scale01440. 00000 - "column to be modified must be empty to decrease precision or scale", workround ora-01440
Set all values in the column to NULL before decreasing the numeric precision or scale. If attempting to increase the scale, increase the precision in accordance with the scale or set all values in the column to NULL first.