I find that the worst problems I have with SQL*Loader tend to be
language related. The same goes with export/import. I wish there were
better documentation on the NLS parameters.
and yes, it was characterset. What I didn't understand was why when I
selected from NLS_DATABASE_PARAMETERS it showed the proper settings yet
I couldn't load. NLS_LANG was unset in Unix/
one of these days I might actually learn something about Oracle :)
- Jonathan Gennick <listmail_at_gennick.com> wrote:
> On Mon, 26 Aug 2002 13:41:50 -0800, Rachel wrote:
>
> >I am not, by any means, a SQL*Loader expert (Jonathan, I keep
> meaning
> >to get your book!)
>
> Sounds like you've solved this one already, but since you invoked my
> name (and in vain too, since I was of no help <grin>), I'll just
> chime
> in to say that my best guess is that you are encountering a character
> set translation issue. Not sure my book would help much with this. I
> don't recall delving into character sets in the book. I'll have to
> correct that omission when I do the revision.
>
> I will say that I've recently had occasion to delve into Oracle's
> support of Unicode (for Steven Feuerstein's upcomming PL/SQL, Third
> Edition). It's incredible how complicated something so seemingly
> simple (on the surface) can be.
>
> Jonathan Gennick --- Brighten the corner where you are
> mailto:jonathan_at_gennick.com * 906.387.1698
> http://Gennick.com * http://MichiganWaterfalls.com *
> http://ValleySpur.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jonathan Gennick
> INET: listmail_at_gennick.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).
Received on Fri Aug 30 2002 - 13:18:44 CDT
