Database Error Messages

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

ORA-39267

Cannot remove default from table column.

Cause

DBMS_METADATA_DIFF was comparing two table columns, one with a default value, one without. There is no SQL ALTER syntax to remove a column default.


Action

The difference cannot be eliminated with an SQL ALTER statement.