|
-
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.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|