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

    user13061399

      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.

      e.g.:

      instead:

      ..

      col1,

      ...

       

      ..

      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