SQL*LOAD problem - loading date/time [message #162271] |
Thu, 09 March 2006 08:23 |
pday@tullib.com
Messages: 11 Registered: March 2006 Location: London
|
Junior Member |
|
|
Hi
I'm having problems loading a date into my table.
The col in the table is defined as a date.
The ctl file line looks like this
local_entry_date DATE 'DD/MM/YYYY HH:MI',
the data in the flat file looks like this
10-Oct-2005 15:40
and the error in the log file is
Record 1: Rejected - Error on table TRAX_FINES, column LOCAL_ENTRY_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected
I've tried various permatations but nothing works.
If I remove the time element from the data file and set the col to a date the data loads fine. Trouble is I need the time element to load.
Any help gratefully received.
thanks
|
|
|
|
|