3 Replies Latest reply: Sep 14, 2013 8:23 AM by user13061399 RSS

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


      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