Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-01451 – column to be modified to NULL cannot be modified to NULL

Oracle Database Error Code ORA-1451 Description :

column to be modified to NULL cannot be modified to NULL

Error Cause:

the column may already allow NULL values, the NOT NULL constraint is part of a primary key or check constraint.

How to Solve :

if a primary key or check constraint is enforcing the NOT NULL constraint, then drop that constraint.