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.