Oracle Error ORA-30082: datetime/interval column to be modified must be empty to decrease fractional second or leading field precision

Oracle Error Message

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

Reason for the Error

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

Solution

Such columns are only allowed to increase the precisions.