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



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

Post New Answer

More Oracle Errors Interview Questions

ORA-28003: password verification for the specified password failed

1 Answers  


NZE-28838: no identity descriptor

1 Answers  


ORA-00050: operating system error occurred while obtaining an enqueue

1 Answers  


TNS-00253: Error in reading network configuration data from file string with error string

1 Answers  


ORA-28235: algorithm not available

1 Answers  






TNS-00279: Navigator: Failed to Start Tracing

1 Answers  


RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile number

1 Answers  


TNS-00530: Protocol adapter error

1 Answers  


ORA-31081: name not specified for global declaration

1 Answers  


ORA-27209: syntax error in device PARMS - unknown keyword or missing =

1 Answers  


ORA-27017: skgfcls: media handle returned by sbtinfo exceeds max length(SSTMXQMH)

1 Answers  


ORA-31638: cannot attach to job string for user string

1 Answers  


Categories