Re: SQL*Loader-625: Multibyte character error in control file
Date: Thu, 02 May 2002 19:34:30 GMT
Message-ID: <axgA8.29944$iJ.8010_at_nwrddc02.gnilink.net>
"george lewycky" <gelewyc_at_nyct.com> wrote in message
news:68aecc05.0205020625.7e9a839a_at_posting.google.com...
> Hi everyone,
> Im trying to load a file into a table and I cant figure out what is
> causing this ?
> The message doesnt tell me too much, nor does the log file
>
> what is this multi-byte character string ?? i searched the web for
> info and indications of the cause but nothing is obvious.
>
> Its indicating something wrong with my control file (below) but its
> quite simple and straightforward and I used a working copy I had
> before and just changed the fields and the filename.
>
> Any suggestions or ideas would be appreciated
>
> thanks in advance
>
> George Lewycky
> NY City Transit
> Brooklyn, NYC
> gelewyc_at_nyct.com
>
>
> SQL*Loader: Release 8.1.7.0.0 - Production on Thu May 2 10:07:31 2002
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> SQL*Loader-625: Multibyte character error in control file.
>
> ---------------------------------------------
>
> LOAD DATA
> INFILE 'C:\MY SQL\cust_apr30.txt’ <<<<<--------Here
> REPLACE
> INTO TABLE TEMP_CUST_INT
> FIELDS TERMINATED BY '","'
>
Look at your control file carefully. Looks as if you got your INFILE name ending with garbage.
--- Jon Yi, ??? software engineering with C, Oracle, Unix, Tcl, MS Access, and Shell programming.Received on Thu May 02 2002 - 21:34:30 CEST