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 |
TNS-01027: Listener Trace File string
ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.
ORA-01952: system privileges not granted to 'string'
PLS-00734: Illegal use of an associational parameter with a formal ellipsis
NNL-00831: Deletes refused, name is not a leaf name: number
ORA-22865: more than one column specified
ORA-03119: two-task detected inconsistent datatype specification
ORA-30156: Out of disk space
ORA-21602: operation does not support the specified typecode
QSM-02113: expression in select list references multiple tables or views
PROC-00010: Cannot delete the cluster registry key as subkeys exist.
ORA-00275: media recovery has already been started