ORA-14120: incompletely specified partition bound for a DATE
column
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-25293: Remote Recipient Subsribers and buffered operations not possible for Queue string
QSM-01054: no join match between query and summary, string
ORA-07755: slemcf: fseek before read failure
ORA-08182: operation not supported while in Flashback mode
ORA-30365: left relation in the JOIN KEY clause cannot be same as right
ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified
ORA-12637: Packet receive failed
ORA-02009: the size specified for a file must not be zero
ORA-07468: spwat: mset error, unable to set semaphore.
SQL*Loader-02050: Multibyte character error.
ORA-27198: skgfpvl: sbtpcvalidate returned error
DRG-11614: URL store: communication with host specified in string timed out