|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
January 11th, 2005, 02:59 PM
|
||||
|
||||
|
request sqlldr date formatting help
Hi! I am trying to import data from a CSV (exported from sybase) into Oracle via sqlldr.
In my control file, I have specified the date format thusly: Quote:
In the CSV file, the date looks like this: Quote:
When I run it against sqlldr, it says this in the logfile: ORA-01843: not a valid month What does it think is going on that I am not seeing? thanks for any help!
|
|
#2
January 11th, 2005, 03:09 PM
|
|||
|
|||
|
well, sorry about that. I have solved it by removing the double-quotes around my date fields (Even though the quotes don't interfere with any other fields -- I used
Quote:
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > request sqlldr date formatting help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
