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

PLS-00603: GROUPING function supported only with GROUP BY CUBE or ROLLUP

1 Answers  


ORA-00075: process "string" not found in this instance

1 Answers  


HI ALL, I AM FACING DATABASE ERROR EXP-00002 IN ORACLE 10G, WIN XP OS. PLS HELP ME TO SOLVE THIS PROBLEM. AM NEW TO DBA ACTIVITIES

1 Answers  


TNS-01190: The user is not authorized to execute the requested listener command

1 Answers  


ORA-22053: overflow error

1 Answers  


ORA-36800: (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP

1 Answers  


ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state

1 Answers  


TNS-01060: The password has has been set to: string

1 Answers  


ORA-23471: template not authorized for user

1 Answers  


ORA-14006: invalid partition name

1 Answers  


ORA-22061: invalid format text [string]

1 Answers  


NZE-28770: Data source is already initialized.

1 Answers  


Categories