| Re: trimming char to fit into date column ORA-01830 [message #100244] |
Thu, 19 September 2002 14:36 |
kwalther
Messages: 9
Registered: April 2002
|
Junior Member |
|
|
Received the same error. It seems that M$ access
was passing a time '0:00:00' format at the end
of a date field that I was trying to import into
oracle using sqlldr. It just wouldn't fit. The
moral of the story is that it's best to export
all data from M$ access as a text file, then use
a bind variable in sqlldr to change it into the
column datatype of the oracle table you made to
accept it. Example:
column_m
position(10:20)"to_date(:column_m,'DD/MM/YY')",
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
