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 |
RMAN-08109: channel string: restored block(s) from backup piece string
IMG-00810: boundary queue initialization failed
SQL*Loader-00261: illegal use of TERMINATED BY for RAW field
NNL-01066: Statistic counter logging interval: string
TNS-12218: TNS:unacceptable network configuration data
DGM-16948: Can not proceed to switchover. Primary is still "string".
ORA-06043: NETDNT: message send failure
PLS-00230: OUT and IN OUT formal parameters may not have default expressions
UDE-00002: invalid username or password
DRG-10709: this preference is referenced by string and cannot be dropped
SQL*Loader-00260: TERMINATED BY EOF option available only with LOBFILE option
PLS-00398: wrong number of columns in UNION, INTERSECT, or MINUS expression