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-22291: Open LOBs exist at transaction commit time

1 Answers  


ORA-30187: reserved for future use

1 Answers  


RMAN-06720: file "string" removed from catalog

1 Answers  


ORA-07225: sldext: translation error, unable to expand file name.

1 Answers  


NNL-00292: Scheduled statistic counters to be reset in string

1 Answers  


ORA-01686: max # files (string) reached for the tablespace string

1 Answers  


NNL-00208: Cancelled reload check

1 Answers  


EXP-00038: Bad Hash cluster id in clu$

1 Answers  


ORA-38404: schema extension not allowed for the attribute set name

1 Answers  


ORA-24801: illegal parameter value in OCI lob function

1 Answers  


RMAN-06192: maximum value for MAXPIECESIZE or MAXSETSIZE must be between 1 Kb and 2048 Gb

1 Answers  


PROC-00018: The value size passed is too large

1 Answers  


Categories