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-28003: password verification for the specified password failed
NZE-28838: no identity descriptor
ORA-00050: operating system error occurred while obtaining an enqueue
TNS-00253: Error in reading network configuration data from file string with error string
ORA-28235: algorithm not available
TNS-00279: Navigator: Failed to Start Tracing
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile number
TNS-00530: Protocol adapter error
ORA-31081: name not specified for global declaration
ORA-27209: syntax error in device PARMS - unknown keyword or missing =
ORA-27017: skgfcls: media handle returned by sbtinfo exceeds max length(SSTMXQMH)
ORA-31638: cannot attach to job string for user string