Oracle 26ai

ORA-01439

Error Message

column to be modified must be empty to change datatype

Cause

An ALTER TABLE MODIFY statement attempted to change the datatype of a column containing data. A column whose datatype was to be altered must contain only NULL values.

Action

To alter the datatype, first set all values in the column to NULL.