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-32330: invalid operation on online redefinition interim table "string"."string"

1 Answers  


DRG-50865: failed to append to collection

1 Answers  


ORA-28047: database is not a member of any enterprise domain in OID

1 Answers  


ORA-07444: function address string is not readable

1 Answers  


ORA-24094: invalid transformation, target type does not match that of the queue

1 Answers  






DRG-12406: invalid CTX EXEC tag attribute (string)

1 Answers  


ORA-38735: Wrong log number string in flashback log file header.

1 Answers  


ORA-22884: object modification failed

1 Answers  


NID-00107: File I/O error on datafile "string" during string operation (number/string)

1 Answers  


ORA-29823: object being analyzed is not a table

1 Answers  


TNS-00082: NOTE: the user MUST specify a trace level

1 Answers  


ORA-00152: current session does not match requested session

1 Answers  


Categories