ORA-01451: column to be modified to NULL cannot be modified
to NULL



ORA-01451: column to be modified to NULL cannot be modified to NULL..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00314: TABLE declarations are not allowed as PL/SQL local variables

1 Answers  


TNS-00313: Navigator: Failed to get version information

1 Answers  


PLS-00533: Tables of non_queryable types are not supported.

1 Answers  


ORA-09746: smscre: shared memory attach address incorrect.

1 Answers  


ORA-25466: data not specified for variable name: string

1 Answers  






DRG-11422: linguistic initialization failed

1 Answers  


ORA-22064: invalid NLS parameter string [string]

1 Answers  


KUP-11001: files not from the same unload operation

1 Answers  


ORA-12486: effective max labels and min labels cannot be changed

1 Answers  


DRG-11526: filename exceeds maximum length

1 Answers  


NCR-02005: NCRF: Invalid session mode

1 Answers  


ORA-27025: skgfqsbi: invalid media manager context area size

1 Answers  


Categories