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

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14752：Interval表达式不是正确类型的常量,
.原因：您尝试使用非固定间隔或其数据类型与分区列不对应的间隔,
.操作：仅对间隔使用常量表达式。如果分区列的数据类型是数字，则间隔必须是数字常量。如果数据类型是日期/时间类型，则间隔必须是间隔类型的常量,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题