| sql loader error [message #71864] |
Wed, 22 January 2003 15:46  |
jinga
Messages: 116
Registered: January 2003
|
Senior Member |
|
|
'ddmonyyyy:hh:mi:ss' I have given this format in the control file for one of the column.But the actual value in the txt file (data file) has the format
14JAN2003:17:04:23.220
when I run the loader I am getting this error.
ORA-01849: hour must be between 1 and 12
I understand the error, but what format string i should give in my control file so that it accepts 24 hour period. and also i want to know how to specify milli seconds in the format
thank you
|
|
|
|
|
|
| Re: sql loader error [message #71869 is a reply to message #71866] |
Thu, 23 January 2003 08:20  |
jinga
Messages: 116
Registered: January 2003
|
Senior Member |
|
|
Thank you.. But do you know what format string i need to put so that i get milli seconds also. I am getting this error because i dont have any format string for the milli seconds..
ORA-01830: date format picture ends before converting entire input string
|
|
|
|
| Re: sql loader error [message #71942 is a reply to message #71866] |
Sun, 09 February 2003 14:01 |
Dom
Messages: 9
Registered: February 2002
|
Junior Member |
|
|
Did you solve this ?
I have a similar problem 8.1.7 target DB and SQLServer 7 and 6.5 source DB's with dates in this format.... including milli seconds.
Only way 'around' the problem I've so far found are cludgey to say the least...
1. Used a fixed width format to ignore the .nnn fractions of a second.
2. Import to a VARCHAR2 column and then extract the major portion of the date and time once in Oracle
3. Add a CHAR column in SQL data pre extract and inserts dates in Oracle format and MASK SQLLoad it once extracted to flat file.
4. Ignore the data completely... in those columns (if you can!)
Oracle 9i will allow the import simply :-)
Doesn't appear to be an easy way around this one....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
