SQLLDR load file with single column
<p>First time using sqlldr, simply trying to load a file with single column, and cannot find a proper way to do it :(
What do I put as a delimiter?</p>

<p>Here's my .ctl file :</p>

<pre><code>load data
 infile 'myfile.dat'
 into table mytable
 fields terminated by ''
 (mycolumn)
</code></pre>

<p>I keep getting errors in the .log like :</p>

<pre><code>Record 4: Rejected - Error on table ..., column ....
ORA-12899: value too large for column "... (actual: 80, maximum: 24)
</code></pre>

<p>Even though the values in the file are max 8 chars each or smth :
string1
string2
string3</p>

<p>Any help will be much appreciated.</p>

<p>Many thanks,
G</p>