Re: Help Use of Loader

On Mon, 24 Aug 1998 11:39:32 -0500, Geraldine Grubb <ggrubb_at_indiana.edu> wrote:

>Hi,
>
>I am trying to use Oracle Loader in Oracle8 to bring in a simple text
>file:
>ggrubb,jsmith,jdoe and so on.
>
>I created the following control file and saved it as a text file:
>load data
>infile 'c:\userscript'
>into table usertest
> (uname position(01:10) char)
>
>I had already created the table usertest with uname char(10)
>I then went to SQLloader and tried to load the infile into the
>userscript.ctl file and no go. It said invalid column name when using
>describe. But when I use describe with SQL it works OK.
>
>Any suggestions?????
>
>Thanks,
>Geraldine
>

use varchar2(10) instead of char Received on Tue Sep 01 1998 - 04:54:08 CDT