Re: Direct exports

"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 - 15:23:03 CST