Database Error Messages

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

ORA-30667

cannot drop NOT NULL constraint on a DEFAULT ON NULL column

Cause

The NOT NULL constraint on a DEFAULT ON NULL column could not be dropped.


Action

Do not drop the NOT NULL constraint on a DEFAULT ON NULL column. The only way to drop the constraint is to remove the ON NULL property of the column default.