Database Error Messages

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

ORA-30672

cannot drop NOT NULL constraint on an identity column

Cause

The NOT NULL constraint on an identity column could not be dropped.


Action

Do not drop the NOT NULL constraint on an identity column. The only way to drop the constraint is to remove the identity property of the column with ALTER TABLE MODIFY column DROP IDENTITY.