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

admin

ORA-14120:incompletely specified partition bound for a DATE column
Cause: An attempt was made to use a date expression whoseformat does not
fully (i.e. day, month, and year (including century)) specify a date as apartition
bound for a DATE column. The format may have been specified explicitly (using
TO_DATE() function) or implicitly (NLS_DATE_FORMAT).
Action: Ensurethat 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.