ORA-01840: input value not long enough for date format
sanju2Mar 29 2010 — edited Mar 31 2010Hi All,
I trying to upload data using sql loader and i get the following error -
Record 1: Rejected - Error on table PLANS, column OPERATION_DATE.
ORA-01840: input value not long enough for date format
My ctl file is --
LOAD DATA
INFILE 'PLANS.txt'
BADFILE 'plans_ctl.bad'
DISCARDFILE 'plans_ctl.dsc'
INSERT
INTO TABLE PLANS
fields terminated by '|'
(
PLAN_ID INTEGER,
OPERATION_DATE DATE 'YYYY-MM-DD',
GROUP_ID INTEGER,
STATION_ID INTEGER,
SHIFTGROUP_ID INTEGER,
PREPLAN_IND INTEGER,
ACTIVE_IND INTEGER
)
Below is the sample data file content ----
210914|2010-03-26|122|81|82|0|1|
210915|2010-03-26|122|81|81|0|1|
210916|2010-03-26|121|81|81|0|1|
Dabase Details:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
OS: Win XP
thanks in adv.
sanju.