Home » RDBMS Server » Server Utilities » field in datafile exceeds maximum length  () 1 Vote
field in datafile exceeds maximum length [message #222273] Fri, 02 March 2007 10:55 Go to next message
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 #222434 is a reply to message #222273] Sun, 04 March 2007 13:53 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA
Senior Member
If you do not specify a datatype and length in your SQL*Loader control file, it defaults to char(255), so you need to specify char(4000) in your SQL*Loader control file for your column that is varchar2(4000) in your table.
Re: "field in datafile exceeds maximum length" for number field [message #222596 is a reply to message #222434] Mon, 05 March 2007 10:18 Go to previous messageGo to next message
Ammo102
Messages: 3
Registered: March 2007
Junior Member
thanks barbara
im really greatful, that worked a treat
Re: "field in datafile exceeds maximum length" for number field [message #222729 is a reply to message #222596] Tue, 06 March 2007 04:14 Go to previous messageGo to next message
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

Re: "field in datafile exceeds maximum length" for number field [message #222831 is a reply to message #222729] Tue, 06 March 2007 09:42 Go to previous message
Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA
Senior Member
The following section of the SQL*Loader portion of the Utilities Guide in the Oracle online documentation deals with loading clob data from a primary data file.

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_loading.htm#i1008564
Previous Topic: Error when colone/copy user
Next Topic: IMP-00017 Error
Goto Forum:
  


Current Time: Thu Dec 12 08:50:20 CST 2024