| Language problem [message #294804] |
Sat, 19 January 2008 06:00  |
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 #294830 is a reply to message #294809] |
Sat, 19 January 2008 21:10  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
