Home » RDBMS Server » Server Administration » Can't change NLS_LANG in Oracle XE
Can't change NLS_LANG in Oracle XE [message #269589] Sun, 23 September 2007 12:16 Go to next message
danielwobeto
Messages: 1
Registered: September 2007
Junior Member
I installed Oracle Express Edition on Windows XP.
Then, I changed the NLS_LANG key in the registry to AMERICAN_AMERICA.WE8ISO8859P1, but the NLS support information does not change from the following:

NLS_CHARACTERSET AL32UTF8
NLS_COMP BINARY
NLS_CURRENCY R$
NLS_DATE_FORMAT DD/MM/RR
NLS_DATE_LANGUAGE BRAZILIAN PORTUGUESE
NLS_DUAL_CURRENCY Cr$
NLS_ISO_CURRENCY BRAZIL
NLS_LANGUAGE BRAZILIAN PORTUGUESE
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_NCHAR_CONV_EXCP FALSE
NLS_NUMERIC_CHARACTERS ,.
NLS_SORT WEST_EUROPEAN
NLS_TERRITORY BRAZIL
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZR
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR

Thank's for any help.
Re: Can't change NLS_LANG in Oracle XE [message #270049 is a reply to message #269589] Tue, 25 September 2007 09:03 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello danielwobeto,

Please read OraFAQ Forum Guide.

Create another DB with your desired NLS and export... or
Which parameter do you want to change?
Please be specific... and put the code inside code tag.
SQL> show parameter nls;


Regards,


mson77

[Updated on: Tue, 25 September 2007 09:26]

Report message to a moderator

Re: Can't change NLS_LANG in Oracle XE [message #270303 is a reply to message #269589] Wed, 26 September 2007 08:16 Go to previous message
naveenmelbourne
Messages: 15
Registered: August 2007
Junior Member
Hi!
Once you set the nls parameter cannot change it parmenantly.
Create new Database with your choice nls..
Other option is use
ALTER SESSION SET NLS_LANGUAGE= AMERICAN ;
it will change for that session only...
thats what I think.

Naveen

[mod-edit] removed illiterate IM speak.

[Updated on: Wed, 26 September 2007 12:49] by Moderator

Report message to a moderator

Previous Topic: Trying to putinto archivelog mode-shutdown and can't restart
Next Topic: session get locked
Goto Forum:
  


Current Time: Wed Dec 07 16:48:23 CST 2016

Total time taken to generate the page: 0.12453 seconds