Database Error Messages

OCI-01449

Column contains NULL values. Cannot alter column to NOT NULL.

Cause

An ALTER TABLE MODIFY statement attempted to change the column definition to NOT NULL when NULL values were present in the column.


Action

Set all NULL values in the column to values other than NULL before attempting the ALTER TABLE MODIFY statement. You must not have NULL values in a column you want to modify to NOT NULL.