Re: Sql * Loader

[Quoted] In fact, no... but you can do it nevertheless.

Assuming your Oracle version is > 8i, there is a new keyword "FILLER" than you can use to reach your need : use '*' (single star) as a separator, and modify your control file so that 5 fields will be loader from your data file.

[...]

   name CHAR TERMINATED BY "*" ...,
   dummy1 FILLER CHAR EXTERNAL TERMINATED BY "*" ...,    town CHAR TERMINATED BY "*" ...,
   dummy2 FILLER CHAR EXTERNAL TERMINATED BY "*" ...,    country CHAR TERMINATED BY "*" ...,
[...]

Obviously, the "dummy" fields are not needed in the destination table.

Hope this helps...

-- 
David