sql*loader problem

[manjunathk]

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]

[marist89]

When I changed your data to:
3607551298,'30-jan-2050 13:30:00',3111188
3607551428,30-jan-2050 13:30:00,2160118
3607551484,30-jan-2050 13:30:00,3934798

I got:
Record 1: Rejected - Error on table TABLE_A, column E.
ORA-01858: a non-numeric character was found where a numeric was expected


Table TABLE_A:
2 Rows successfully loaded.
1 Row 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.

When I changed your control file to:
load data
infile *
append
into table table_a
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED 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

I got:
Table TABLE_A:
3 Rows successfully loaded.
0 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.