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.