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-08192: Flashback Table operation is not allowed on fixed tables

1 Answers  


ORA-24320: unable to initialize a mutex

1 Answers  


ORA-16636: the object is permanently disabled

1 Answers  


ORA-33284: (DBERR12) Analytic workspace string cannot be opened in MULTI mode before converting it by the latest version of string.

1 Answers  


ORA-30567: name already used by an existing log group

1 Answers  






ORA-29305: cannot point-in-time recover tablespace 'string'

1 Answers  


PLS-00648: type of supertype attribute "string" can not be a subtype or reference to a subtype in this release

1 Answers  


ORA-27081: unable to close the file

1 Answers  


NNO-00315: server is listening on address string

1 Answers  


ORA-26001: Index string specified in SORTED INDEXES does not exist on table string

1 Answers  


ORA-22873: primary key not specified for primary key based object table

1 Answers  


ORA-28650: Primary index on an IOT cannot be rebuilt

1 Answers  


Categories