ORA-14120: incompletely specified partition bound for a DATE column

ORA-14120: 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)). If NLS_DATE_FORMAT does not support complete (i.e. including the century) specification of the year, use TO_DATE() (e.g. TO_DATE('01-01-1999', 'MM-DD-YYYY') to fully express the desired date.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14120：为DATE列绑定的不完全指定的分区,
.原因：试图使用格式不完全（即日，月和年（包括世纪））的日期表达式指定日期作为DATE列的分区绑定。格式可能已明确指定（使用TO_DATE（）函数）或隐式（NLS_DATE_FORMAT）。,
.操作：确保在为DATE列绑定的分区中使用的日期格式支持日期（即日，月和年（包括世纪））的完整指定。如果NLS_DATE_FORMAT不支持年份的完整（即包括世纪）规范，请使用TO_DATE（）（例如TO_DATE（'01 -01-1999'，'MM-DD-YYYY'）完全表示所需的日期。,
.

aiaiDBA

13718043309

010-86462881

ORA-14120: incompletely specified partition bound for a DATE column

1 个回答

相似问题