Re: SQL*Load

On 7 Sep 1998 19:34:22 GMT, rjschulzsj_at_aol.com (RJSchulzSJ) wrote:

>how can I load ascii-files with german characters (äöüß) into oracle tables. I
>can insert the data with an odbc-client and with serverside sqlplus etc., but I
>can't insert it with sql*load. WHY and HOW?

You can. If your NLS_LANG environment doesn't recognise the characters from your ascii file characterset, you can set the particular characterset in your loader's controlfile. You specify it just before you specify the input file. The syntax is

    "CHARACTERSET characterset_name",
 for example CHARACTERSET WE8ISO8859P1

>greetings from
>r.j.schulz (berlin)

HTH

--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
================================================
The above opinions are mine and do not represent
any official standpoints of my employer