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

DGM-16903: Unable to connect to database

1 Answers  


QSM-02024: no GROUP BY clause

1 Answers  


TNS-12592: TNS:bad packet

1 Answers  


TNS-00285: Avg Connect Time (secs) : number

1 Answers  


ORA-29284: file read error

1 Answers  






RMAN-05018: some datafile copies cannot be recovered, aborting the RECOVER command

1 Answers  


TNS-12550: TNS:syntax error

1 Answers  


NNL-00013: not performed, permission denied for supplied password

1 Answers  


ORA-26041: DATETIME/INTERVAL datatype conversion error

1 Answers  


IMP-00094: Warning: The identifier on the dump file for object type "string"."string" is invalid

1 Answers  


ORA-31658: specifying a schema name requires a table name

1 Answers  


ORA-01413: illegal value in packed decimal number buffer

1 Answers  


Categories