ORA-01451: column to be modified to NULL cannot be modified to NULL - Oracle Database 12c Error Msg

Channel:

java frm

Subscribers:

5,740

Published on March 13, 2023 8:40:20 AM ● Video Link: https://www.youtube.com/watch?v=BIaBSmFAW-Y

Duration: 1:33

18 views

0

In this video we are going to see how to fix below Oracle Database 12c Error Message.

ORA-01451: column to be modified to NULL cannot be modified to NULL
Cause: the column may already allow NULL values, the NOT NULL constraint is part
of a primary key or check constraint.
Action: if a primary key or check constraint is enforcing the NOT NULL constraint,
then drop that constraint.

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database