I have some data I am trying to load into an Oracle table through
sqlldr. One of the fields is a date field. The following is a sample
value:

2006-10-16T16:37:59Z

In my control file the field is identified as 'DateGenerated date'. I
tried to load the data with the data type field of CHAR just to get it
into the database and I got the following error:

Record 1: Rejected - Error on table TR, column DATEGENERATED.
ORA-01861: literal does not match format string

How would I modify this field entry so that it can successfully load the
data above?

Raquel Sikyala


Oracle LazyDBA home page