-
ORA-01830 date format picture ends
before converting entire input string
- Cause: A valid date
format picture included extra data. The first part of
the format picture was converted into a valid date, but
the remaining data was not required.
- Action: Check the
specifications for date format pictures and correct the
statement.
MOSC has information
referring to ORA-01830 in which users find that their RMAN
backup fails with ORA-01830, this has been occurring in
Oracle Enterprise 10.2.0.3.0 on al platforms.
Here is an example of how ORA-01839 is being thrown:
RMAN-00571:
============================================
RMAN-00569: =============== ERROR MESSAGE STACK
FOLLOWS
===============
RMAN-00571: ============================================
RMAN-03009: failure of backup command on t1 channel at
05/07/2007 07:14:42
ORA-01830: date format picture ends before converting
entire input string
MOSC
informs that ORA-01839 is being caused by an incorrect NLS
path. ORA-01830 can be resolved with the correct
NLS_LANG, as well as the proper ORA_NLS33 environmental
table. Here is an example:
$export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
$export ORA_NLS33=<full path to $ORACLE_HOME/ocommon/nls/admin/data
If you are experiencing
ORA-01839 because you have questions about date a time
formatting, check out
this great blog (by Jon Emmons), covering the basics, as
well as a few great examples.
If
using SQL*Loader, you can get the ORA-01839 error if the
nls_date_format does not match the data:
05/06/2009
11:08:49 PM
alter session set
nls_date_format='DD/MM/YYYY';
sqlldr . . .
ORA-01830 date format picture ends
before converting entire input string
To avoid the ORA-01839 error, the statement was changed:
alter session
nls_date_format='DD/MM/YYYY HH:MM:SS AM';
