Home » SQL & PL/SQL » SQL & PL/SQL » Language problem (10g, windows xp)
Language problem [message #294804] Sat, 19 January 2008 06:00 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Guys,

I starting at a company as a junior dba. There is problem with the commands in the oracle everything is in a weird language. I tried typing commands in command prompt but the errors are in a different language (or may be just signs). The forms and reports that are there also show commands in different language.

What to do? I know it has something to do with the NLS_LANGUAGE parameter but how to change it English

- Das

Re: Language problem [message #294809 is a reply to message #294804] Sat, 19 January 2008 07:13 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
This may help: http://www.orafaq.com/wiki/NLS_LANG
Re: Language problem [message #294830 is a reply to message #294809] Sat, 19 January 2008 21:10 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks

I assume we are supposed to use this command to change the language format

alter system set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

or is it

alter database set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

actually I tried both and it did not seem to work

would you know the reason why?

- Das
Re: Language problem [message #294842 is a reply to message #294830] Sun, 20 January 2008 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ NLS_LANG is a CLIENT parameter not a SERVER one
2/ NLS_LANG is static

Regards
Michel
Re: Language problem [message #294857 is a reply to message #294804] Sun, 20 January 2008 04:18 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Don't you think it would be safer to ask your senior DBA?
Previous Topic: how to query max(date) plus tuning
Next Topic: Help -> DBMS_JOB.BROKEN
Goto Forum:
  


Current Time: Sat Dec 10 14:43:23 CST 2016

Total time taken to generate the page: 0.24234 seconds