ORA-14120: incompletely specified partition bound for a DATE
column
- 1 Answers
- 4069 Views
- I also Faced
- E-Mail Answers
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-23422: Oracle Server could not generate an unused job number
ORA-29341: The transportable set is not self-contained
ORA-16574: switchover disallowed when required databases are offline
NNL-00239: Resetting of statistic counters is now disabled
ORA-30189: reserved for future use
ORA-25265: specified signature for a queue which does not support reciever non-repudiation
TNS-01041: %s parameter "string" set to string
ORA-12025: materialized view log on "string"."string" already has primary keys
ORA-09809: Unable to get user's group ID from connection
ORA-10635: Invalid segment or tablespace type
ORA-25211: invalid DELAY specified when using sequence deviation
ORA-31628: error getting worker process exception
Oracle Errors 
