Search notes:

Oracle: NOT NULL constraint

The not null constraint prevents a column value from being null. Thus, the not null constraint is a special check constraint.
Columns that are part of a primary key or identity columns are always not null.

See also

The error messages:

Index