Home » RDBMS Server » Server Utilities » Field in data file exceeds maximum length (Oracle R12, Windows7)
Field in data file exceeds maximum length [message #600967] Thu, 14 November 2013 05:03 Go to next message
adit102
Messages: 9
Registered: November 2010
Junior Member
Hi,

I am loading data in new instance using CTL file. But getting error as 'Field in data file exceeds maximum length' for few records. Remaining records are getting inserted successfully.

Log file, Control file, Table description etc. here

Is this error because of the special characters used?

Please let me know what changes do I need to make.

Thanks,
Aditya


[EDITED by LF: applied [spoiler] tags to shorten a lengthy message]

[Updated on: Thu, 14 November 2013 14:11] by Moderator

Report message to a moderator

Re: Field in data file exceeds maximum length [message #601003 is a reply to message #600967] Thu, 14 November 2013 07:35 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Hi,

If you format your code as is suggested here it'll be easier to read and you'll receive more help.
Re: Field in data file exceeds maximum length [message #601019 is a reply to message #600967] Thu, 14 November 2013 12:09 Go to previous message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
If you do not specify a length for your field in your control file, then it uses the default value of 255. So, if your comments are longer than 255, then you get the error. Since your comments column in your table has a length of 2000, instead of:

COMMENTS "REPLACE(:COMMENTS ,'~' ,' ')",

you should use:

COMMENTS CHAR(2000) "REPLACE(:COMMENTS ,'~' ,' ')",
Previous Topic: unix command from oracle
Next Topic: sql loader
Goto Forum:
  


Current Time: Thu Mar 28 17:14:10 CDT 2024