| SQLLDR date format problem [message #205710] |
Mon, 27 November 2006 03:45  |
tayalarun
Messages: 20
Registered: December 2005
|
Junior Member |
|
|
Hi,
I am using oracle 10.2.0.2.0 and running sqlldr for loading the flat file.
All things are fine But when I use date format as :
cdate DATE 'yyyy-mm-dd hh24:mi:ss.FF3',
it gives the error : ORA-01821: date format not recognized
My flat file have the date in this format.
Any clue...
Thanks & Regards
Arun Tayal
|
|
|
|
| Re: SQLLDR date format problem [message #205745 is a reply to message #205710] |
Mon, 27 November 2006 05:26  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
The DATE datatype does not support fractional seconds. Try TIMESTAMP instead (assuming you are loading into a TIMESTAMP column, and not a DATE column).
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
