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
ORA-14752表示间隔表达式的类型错误，它可能有以下两个原因：
1）给定的间隔表达式不是正确类型的常量。
2）给定的间隔表达式类型为空或无效。
官方解释
此错误消息通常将在您尝试在SQL语句中使用常量作为间隔表达式时显示，并且这个间隔表达式的类型不正确，缺少信息或无效。
常见案例
RMAN恢复操作中可能会出现ORA-14752错误，如下所示：
RMAN> RESTORE DATABASE;
Starting restore at 17-JUL-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=25 device type=DISK
ORA-14752: interval expression is not a constant of the correct type
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 17-JUL-19
RMAN-06004: ORACLE error from recovery catalog database
ORA-14752: interval expression is not a constant of the correct type
处理
1）检查间隔表达式的类型。
2）确保提供的表达式有效。
3）更改查询或RMAN脚本，以提供合适的间隔表达式类型。