Oracle分区表增加分区报错“ORA-14760:不允许对间隔分区对象执行 ADD PARTITION”

  • Post author:
  • Post category:其他


为分区表增加分区的时候报错

查看报错代码

[oracle@backup-recovery misdb]$ oerr ora 14120

14120, 00000, “incompletely specified partition bound for a DATE column”

// *Cause:  An attempt was made to use a date expression whose format

//          does not fully (i.e. day, month, and year (including century))

//          specify a date as a partition bound for a DATE column.

//          The format may have been specified explicitly (using

//          TO_DATE() function) or implicitly (NLS_DATE_FORMAT).

// *Action: Ensure that date format used in a partition bound for a

//          DATE column supports complete specification of a date

//          (i.e. day, month, and year (including century)).

//