Database Error Messages

OCI-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 was to be altered must contain only NULL values.


Action

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