Oracle Error ORA-14752: Interval expression is not a constant of the correct type

Oracle Error Message

ORA-14752: Interval expression is not a constant of the correct type

Reason for the Error

You attempted to use either a nonconstant interval or an interval whose data type does not correspond to the partitioning column

Solution

Use only constant expressions for the interval. If the data type of partitioning column is numeric, the interval must be a numeric constant. If the data type is of type date/time, the interval must be a constant of interval type