incompletely specified partition bound for a DATE column

Solution ID:ORA-14120

Type: Oracle

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).

Actions

Bring tablespace online before attempting the operation.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/1571293


https://community.oracle.com/message/1056861


https://community.oracle.com/message/3573871


https://community.oracle.com/message/3940045


https://community.oracle.com/message/3887527


https://community.oracle.com/message/168184


Browse all solutions to database errors from Oracle, MS SQL, or MySQL