Thanks Torgeir for your response. But..

I tried the same but still I am getting messages in english.
Reg key value GERMAN_AMERICA.WE8MSWIN1252(I have only one oracle_home)

NLS_LANG environment variable also set to

C:\>set NLS_LANG=GERMAN_AMERICA.WE8MSWIN1252

C:\>echo %NLS_LANG%
GERMAN_AMERICA.WE8MSWIN1252

C:\>sqlplus scott/[Email Address Removed] Release 9.2.0.4.0 - Production on So Nov 30 11:21:49 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> alter session set NLS_LANGUAGE=GERMAN;
Session altered.


-----Original Message-----
From: Torgeir Toms [mailto:torgeir.[Email Address Removed] Sunday, November 30, 2003 9:58 AM
To: LazyDBA.com Discussion
Subject: SV: Question Reg. NLS_LANGUAGE


Go to regedit, hkey_local_machine\software\oracle\home?\nls_lang - Locate
where it says America_american. Change it to German_American.
Then you will have systemmessages in german
Second question !!! why do you want that - Metalink and oracle support
requiers english. I have tried to translate them back to english from
norwegian -it is not easy. I suppose it is not easier from german.



Med vennlig hilsen
Torgeir Toms
Systemkonsulent Teknisk IT

==================================
Good Judgment Comes From Experience. Experiences Comes From Bad Judgment.
=====================================



-----Opprinnelig melding-----
Fra: Thiagoo [mailto:[Email Address Removed] 30. november 2003 09:46
Til: LazyDBA.com Discussion
Emne: Re: Question Reg. NLS_LANGUAGE


Hi Tamizh,

Pls try this..Am not sure..

Please check your database characterset & national character set..What's ur
current NLS_LANGUAGE & NLS_TERRITORY?..I think this will have an impact...

If am wrong, someone pls corect me..! If you need the system's response to
be in German, there may be some other settings.

-Thanks!

tamizh <[Email Address Removed] wrote:
Hi Gurus,

When I say
SQL> ALTER SESSION SET NLS_LANGUAGE=german;
System altered.

But manual says
SQL> ALTER SESSION SET NLS_LANGUAGE=german;
Session wurde geändert.



==================================================

Thanks & Best Regards,

Thiagu

==================================================


---------------------------------
Do you Yahoo!?
Free Pop-Up Blocker - Get it now

--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page