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.

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

Legend

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