This discussion is archived
3 Replies Latest reply: Sep 14, 2013 6:23 AM by user13061399 RSS

Data Migration to Cloud using SQL Developer -> Field in data file exceeds maximum length Record

user13061399 Newbie
Currently Being Moderated

Hi there,

i have no clue how to import data of tables having columns containing more than 255 characters.

After the Data Deployment the Loader .ctl File says: Field in data file exceeds maximum length...


Google says: You need to adjust the *.ctl File for columns which were larger than 255 characters since that is the default.








col1 CHAR(3000),



The only way i found so far is to adjust it in the generated *.ctl File and to upload the manipulated File manually with sftp. Yet, now i get "VERIFICATION FAILED" when i try to re-execute the Deployment.


Note: The Source- and the Target Column are defined with varchar2(4000 CHAR).


Help is appreciated, Alex


  • Correct Answers - 10 points
  • Helpful Answers - 5 points