| field in datafile exceeds maximum length [message #222273] |
Fri, 02 March 2007 10:55  |
Ammo102
Messages: 3
Registered: March 2007
|
Junior Member |
|
|
Hi
I am currently trying to use sqlldr to load a csv file into a oracle table.
I have a field which is rejecting that record which is description, currently it is varchar2 (4000), the characters are no way near hitting 4000 characters, but does contain non english characters, but this is not the problem for any other column, i only get (Field in data file exceeds maximum length)
for some of the records
can anyone help in any way please!!!!
its doing my head in
p.s iv also tried using CLOB and nope that doesnt work either
|
|
|
|
|
|
|
|
| Re: "field in datafile exceeds maximum length" for number field [message #222729 is a reply to message #222596] |
Tue, 06 March 2007 04:14  |
Ammo102
Messages: 3
Registered: March 2007
|
Junior Member |
|
|
Hi again guys
basically im having a problem still
iv set the table to varchar2(4000)
and in the control file i have set char(4000)
now the problem is some fields have more than 4000 characters
i was trying to changed the varchar2(4000) to CLOB
but when i try to change it in the sql control file it throws an error, iv tried instead of char(4000) inserting clob
if anyone has any ideas please could they let me know
|
|
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
