Re: Help Use of Loader

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Tue, 25 Aug 1998 08:56:51 -0400
Message-ID: <6ruc7s$68p$1@client3.news.psi.net>

Hi Geraldine,

Based on the example you show your control file should specify delimited rather than positional fields. It should look like:

    load data
    iinfile 'c:\userscript'
    into table usertest
    fields terminated by ',' trailing nullcols

regards

Jerry

Geraldine Grubb wrote in message <35E19743.98CA756E_at_indiana.edu>...
>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
>
Received on Tue Aug 25 1998 - 07:56:51 CDT