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-02154: a tablespace with the name 'string' is found
ORA-08331: Wait operation timed out
QSM-02036: in-list present in mv
ORA-22894: cannot add constraint on existing unscoped REF columns of non-empty tables
TNS-12625: TNS:missing argument
ORA-18004: outline already exists
NCR-03004: NCRO: Unknown message
ORA-28519: no heterogeneous data dictionary translations available
ORA-09987: unable to attach to SGA in READ-ONLY mode
RMAN-06453: RECOVERABLE may only be used with datafile objects
ORA-09746: smscre: shared memory attach address incorrect.
ORA-00304: requested INSTANCE_NUMBER is busy