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

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


Cause:


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



Action:


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

About