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
