How to resolve ORA-01449 Error Message in Oracle database

Learn the motive and how to unravel the ORA-01449 error message in Oracle.


When you come across an ORA-01449 error, the following error message will appear:

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


You tried to execute a ALTER TABLE MODIFY command to exchange a column from NULL to NOT NULL, however the column currently contains NULL values in one or extra records.


The option(s) to resolve this Oracle error are:

Option #1

Either delete the data that comprise NULL values or perform an UPDATE to alternate the NULL values to non-NULL values.