How to resolve ORA-01449 Error Message in Oracle database

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

Description

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

Cause

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.

Resolution

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.