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-32330: invalid operation on online redefinition interim table "string"."string"
DRG-50865: failed to append to collection
ORA-28047: database is not a member of any enterprise domain in OID
ORA-07444: function address string is not readable
ORA-24094: invalid transformation, target type does not match that of the queue
DRG-12406: invalid CTX EXEC tag attribute (string)
ORA-38735: Wrong log number string in flashback log file header.
ORA-22884: object modification failed
NID-00107: File I/O error on datafile "string" during string operation (number/string)
ORA-29823: object being analyzed is not a table
TNS-00082: NOTE: the user MUST specify a trace level
ORA-00152: current session does not match requested session