Database Error Messages

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

ORA-30082

datetime/interval column to be modified must be empty to decrease fractional second or leading field precision

Cause

datetime/interval column with existing data is being modified to decrease fractional second or leading field precisions.


Action

Such columns are only allowed to increase the precisions.