Until 22/01/03, the database was 8.1.6. and it got upgraded to 126.96.36.199.1. on 23/01/03.(still on WindowsNT 4.0)
I tried to do an export for the first time since the upgrade and came across the following error:
Connected to: Oracle8i Enterprise Edition Release 188.8.131.52.1 - Production
With the Partitioning option
JServer Release 184.108.40.206.1 - Production
EXP-00041: Export done in server's WE8DEC, different from user's
Character set WE8ISO8859P1
EXP-00000: Export terminated unsuccessfully
which I didn't have before. And I am aware that if I take direct=y off the exp parameter, the exp runs fine.
I have looked up in Metalink about this error, and most common solution is to make sure Server and Client (user) have the same character set. Rather unfortunately, I could not find any practical notes - i.e. with actual syntax of how to change the character set and what impact it might have.
I would appreciate if any of you could help me with the syntax to amend this error.
Rearding the impact - the imp/exp utility will use the local NLS_LANG variable value to produce export dmp file or perform import. If different from the db CS - then you will have character set conversion. A very convenient way to change Oracle DB character set...
When the direct-path option is used, the client-side character set must match the character set of the server side. Use the environment variable NLS_LANG to set the same character set as the server one.