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-13332: invalid LRS point
UDE-00012: table mode exports only allow objects from one schema
KUP-04045: unexpected OCI status string
TNS-02403: Bad alias string or alias not present in tnsnames.ora
QSM-01066: materialized view, string, does not have the column, string, from query
ORA-29337: tablespace 'string' has a non-standard block size (string)
ORA-15192: invalid ASM disk header [string] [string] [string] [string] [string]
ORA-06568: obsolete ICD procedure called
ORA-39053: parameter or attribute string must be defined for a string job
ORA-29313: tablespace 'string' cannot be imported twice
LSX-00290: invalid enumeration choice "~S"
NNL-00513: Shows or sets the server's auto-refresh failure retry interval