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

VID-00714: internal error

1 Answers  


ORA-31030: Unable to retrieve XML document

1 Answers  


ORA-29740: evicted by member string, group incarnation string

1 Answers  


PCC-00114: Length spec required in EXEC SQL VAR statements for VARxxx types

1 Answers  


ORA-32812: subscriber string does not exist

1 Answers  






TNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number.

1 Answers  


ORA-32339: cannot alter materialized view with the PMOP

1 Answers  


ORA-01923: CASCADE aborted, objects locked by another user

1 Answers  


ORA-12334: database (link name string) is still open

1 Answers  


SQL*Loader-00503: Error appending extension to file (string)

1 Answers  


IMG-00512: multiple incompatible scaling parameters found

1 Answers  


DRG-11005: invalid create index parameter string

1 Answers  


Categories