It's freaking out do to the 'Z' in the milliseconds field.

Since I'm on my OMWB kick today, try migrating into a bogus Oracle table
with OMWB, which will truncate the milliseconds, and then use SQL
loader...


Jeffrey C. Ferrel
DMS III
State of Nevada
775.687.9327
[Email address protected]


-----Original Message-----
From: Sikyala Raquel
[mailto:oracledba-ezmlmshield-x99206216.[Email address protected]
Sent: Monday, March 05, 2007 12:36 PM
To: LazyDBA Discussion
Subject: Sqlldr (Problem with loading a date field)

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



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page