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

ORA-13153: invalid high water mark specified

1 Answers  


IMG-00705: unsupported or corrupted input format

1 Answers  


RMAN-20030: resync in progress

1 Answers  


PCC-02043: CMD-LINE: Option syntax is incorrect

1 Answers  


ORA-24316: illegal handle type

1 Answers  






ORA-00439: feature not enabled: string

1 Answers  


ORA-07647: sszfck: $OPEN failure

1 Answers  


LSX-00290: invalid enumeration choice "~S"

1 Answers  


ORA-01570: MINEXTENTS must be no larger than the string extents currently allocated

1 Answers  


ORA-03128: connection is in blocking mode

1 Answers  


ORA-34179: (MXCHGDCL20) workspace object is not a PARTITION TEMPLATE.

1 Answers  


ORA-12710: CREATE CONTROLFILE character set is not known

1 Answers   Orange,


Categories