Database Error Messages

OCI-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