Hi friends,
My control file is as follows:
load data
infile *
append
into table system.table_a
FIELDS TERMINATED BY ","
(
d,
e date "dd-mon-yyyy hh24:mi:ss",
f
)
begindata
3607551298,'30-jan-2050 13:30:00',3111188,
3607551428,30-jan-2050 13:30:00,2160118,
3607551484,30-jan-2050 13:30:00,3934798

When I try to load, it is giving me the following error:

Table SYSTEM.TABLE_A, loaded from every logical record.
Insert option in effect for this table: APPEND

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
D FIRST * , CHARACTER
E NEXT * , DATE dd-mon-yyyy hh24:mi:ss
F NEXT * , CHARACTER

Record 1: Rejected - Error on table SYSTEM.TABLE_A, column D.
ORA-01847: day of month must be between 1 and last day of month

Record 2: Rejected - Error on table SYSTEM.TABLE_A, column D.
ORA-01847: day of month must be between 1 and last day of month

Record 3: Rejected - Error on table SYSTEM.TABLE_A, column D.
ORA-01847: day of month must be between 1 and last day of month


Table SYSTEM.TABLE_A:
0 Rows successfully loaded.
3 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.

The error is obviously wrong because even when I changed the date the same error occured.

Can someone help me with the solution?
thanks
manjunath

my mistake!!!!
the table column D had a date datatype too.
Thanks

[Edited by manjunathk on 01-23-2001 at 06:11 PM]