Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-30665

invalid NOT NULL constraint specified on a DEFAULT ON NULL column

Cause

A NOT NULL constraint was not specified correctly on a DEFAULT ON NULL column.


Action

If a NOT NULL constraint is specified on a DEFAULT ON NULL column, it must be enabled and nondeferrable.