Re: sql loader control file help - solved

gee, this is so cool. The authors I used to read in flesh and blood, and actually giving away a signed copy!

I'm gonna make sure I drop everything and answer the next query Rachel puts. (And then pray hard its right and I get a copy too!)

With Warm Regards,
Manav.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, August 27, 2002 9:18 PM

> Ron,
>
> You were dead on correct (send me your snail mail address offlist and
> I'll send you a signed copy of Oracle9i DBA 101)
>
> Anjo, you were right too but you already have, or should be getting, a
> copy of the book. I'll buy you a beer at the next conference :)
>
> Very strange. I was loading ON the server itself, not from my client.
> Database is 9.2, my client on my PC is 8.1.7. The load worked from my
> PC but not from the server. The pertinent default NLS parameters, from
> NLS_DATABASE_PARAMETERS, when I do NOT set NLS_LANG are
>
> PARAMETER VALUE
> ------------------------------ ----------------------------------------
> NLS_LANGUAGE AMERICAN
> NLS_TERRITORY AMERICA
> NLS_CHARACTERSET WE8ISO8859P1
> NLS_NCHAR_CHARACTERSET AL16UTF16
> NLS_RDBMS_VERSION 9.2.0.1.0
>
> which looks right but the load doesn't work. When I set the Unix
> environment variable NLS_LANG to AMERICAN_AMERICA.WE8ISO8859P1, the
> load works properly. Anyone want to explain THAT to me?
>
> and the docs are, as usual, clear as mud. I figured it out with the
> hints from Ron and Anjo and testing inserts from my PC and the server
> directly.
>
> Hope this helps some other poor soul in the future!
>
> Rachel
>
> --- Ron Thomas <rthomas_at_hypercom.com> wrote:
> >
> > Make sure your environment NLS_LANG matches how the data is encoded
> > in your flat file.
> >
> > Also, does the database characterset handle whatever special
> > characters you are trying to import?
> >
> > Ron Thomas
> > Hypercom, Inc
> > rthomas_at_hypercom.com
> > If A = B and B = C, then A = C, except where void or prohibited by
> > law. -- Roy Santoro
> >
> >
> >
> >
> > root_at_fatcity.com
> >
> > To:
> > ORACLE-L_at_fatcity.com
> >
> > 08/26/02 02:41 PM cc:
> >
> > Please respond to Subject: sql loader
> > control file help
> > ORACLE-L
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > I am not, by any means, a SQL*Loader expert (Jonathan, I keep meaning
> > to get your book!)
> >
> > Here's the thing:
> >
> > I have a flat file with character data that includes special
> > characters
> > (like accents and diacritical marks over letters). When I load the
> > data
> > in using SQL*Loader, the special characters disappear and are
> > replaced
> > by the letter (so Dvorák goes on as Dvorak).
> >
> > How can I get the data in as it should be? I've been reading and will
> > continue to read the fine manual, but I'm not finding this...
> >
> > Help!
> >
> > Rachel
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Finance - Get real-time stock quotes
> > http://finance.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> > Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ron Thomas
> > INET: rthomas_at_hypercom.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> > Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://finance.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Manavendra Gupta
  INET: manav_at_zycus.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).