Tag Archives: ORA-01449

ORA-01449: column contains NULL values; cannot alter to NOT NULL

oracle

ORA-01449: column contains NULL values; cannot alter to NOT NULL
Cause: An ALTER TABLE MODIFY statement attempted to change the definition of a column containing NULL values to NOT NULL. The column may not currently contain any NULL values if it is to be altered to NOT NULL.
Action: Set all NULL values in the column to values other than NULL before ALTERING the column to NOT NULL.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/