Re: Direct exports

Thank you. It worked perfectly.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tao236kri3j134_at_beta-news.demon.nl...
>
> "d1ngo" <dont_at_mail.me> wrote in message
> news:98gf6u$icu$1_at_bob.news.rcn.net...
> > Hello everyone. I read on technet about doing direct exports. But my
 user
> > session is in US7ASCII character set while my server is in WE8ISO8859P1
> > character set. So I did some more reading, and found that I have to set
 the
> > NLS_LANG parameter for the user. Where and how do I set that? And I
 would
> > have to set it to WE8ISO8859P1 since that is what my server uses, right?
> > Well, here's my current export info if it helps:
> >
> > Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character
 set
> > server uses WE8ISO8859P1 character set (possible charset conversion)
> >
> > Thank you.
> >
> >
> Unix
> (in bash and ksh)
> export NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P1"
>
> NT
> add this as a new string variable to hkey\local_machine\software\oracle
>
> BTW: during direct exports *no* characterset conversion can be done.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
>
Received on Sun Mar 11 2001 - 18:23:18 CST