I can’t assist from the Toad side… I still use the command interface for
this task. Perhaps if I outline what I do, that might help you resolve what
you’re running in to.
I tend to use a separate control file and run file as follows.
Run file contents:
Sqlldr control=$HOME/.ctl, log=$HOME/.log, bad=$HOME/.log, \
The is a “your choice” option. For example, I use a generic
load_file.ctl, load_file.dat, etc for my one-off kind of things (that way I only
need modify the control file and ensure the data file is in place).
Control file contents:
LOAD DATA TRUNCATE
FIELDS TERMINATED BY ‘!’
Termination value can be literally any character in the character set you use.
In the above example, I wanted to load each line into a single column so I
picked a character that did not show up anywhere in the file.
Trailing allows you to populate a field value that does not otherwise appear in
your data file. In the above example, it increments an index value so you can
order the data in the exact order it appeared in the data file if that is a
To be able to specify a fixed file, you’d have the following changes in the
Remove termination line. Replace the column definitions with:
( position (001:004),
Hope this helps!