Tag Archives: ORA-01439

ORA-01439: column to be modified must be empty to change datatype

oracle

ORA-01439: 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 is to be altered must contain only NULL values.
Action: To alter the datatype, first set all values in the column to NULL.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/