Re: What is SQL Loader doing here?

Robert,

In your control file you don't specify a datatype for any of the fields (job_type, description, skills etc), so SQLLoader uses the default datatype CHAR, and the default maximum length (255 bytes). You can prove this to yourself by editing one of the "skills" fields down to 256 bytes -> won't load, then take off another character, and it loads OK.

If you want to load > 255 bytes into a field you must explicitly specify a maximum length for that field in the control file, for instance

load data infile *
replace
into table listing
fields terminated by "," optionally enclosed by '"' ( id sequence(max,1),
job_type,
description,
skills CHAR(1000),
...

etc
...

Note that CHAR here is an SQLLoader datatype, not the same as the server CHAR datatype ...

hth
regards
Steve Blomeley Received on Sun Feb 04 2001 - 08:07:39 CST