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-23404: refresh group "string"."string" does not exist

1 Answers  


ORA-30043: Invalid value 'string' specified for parameter 'Undo_Management'

1 Answers  


ORA-06405: NETCMN: reset protocol error

1 Answers  


ORA-07747: slemrd: $READ failure

1 Answers  


ORA-36188: (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.

1 Answers  


IMP-00012: invalid export mode (character) in header

1 Answers  


ORA-14096: tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns

1 Answers  


ORA-25100: TABLESPACE option can only be used with ALTER INDEX REBUILD

1 Answers  


SQL*Loader-00919: Error during upi fetch: [number]

1 Answers  


ORA-01531: a database already open by the instance

1 Answers  


NCR-04020: NCRR: Interface or instance name does not exist

1 Answers  


ORA-02401: cannot EXPLAIN view owned by another user

1 Answers  


Categories