EXP Direct=Y problem 2

[fmorel]

Hi all!

I try to do an export using direct path on a windows client.

I get:

EXP-00041: Export done in server's WE8ISO8859P15, different from user's character set WE8ISO8859P1

So I have to set up my client with WE8ISO8859P15.
I tried to do:
set NLS_CHAR=WE8ISO8859P15
before export command but it did not work.

So the question is:
How do I set up NLS on a windows client?

Thanks for help!

 

[sem]

You may change it in Registry:

NLS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15

 

[dmooreora]

You may have to set this in your reg file for Windows. From the run command line in start -> run... type REGEDIT. Go to the
[HKEY_LOCAL_MACHINE]
[SOFTWARE]
[ORACLE]
and retrieve the NLS_LANG name for Type REG_EXPAND_SZ. YOu can change the data to the new value.

Be VERY CAREFULL when editing your registry file, do not change anything else without knowing what you are doing. My recommendation is to Save the current key data so that you can
insert it back in if this does not work for you.

 

[fmorel]

Thanks a lot!

Great forum, great people !