OraFAQ Forum: Server Administration » Can't change NLS

Home » RDBMS Server » Server Administration » Can't change NLS_LANG in Oracle XE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can't change NLS_LANG in Oracle XE [message #269589]

Sun, 23 September 2007 12:16

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.

Report message to a moderator

Re: Can't change NLS_LANG in Oracle XE [message #270049 is a reply to message #269589]

Tue, 25 September 2007 09:03

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 04:43:37 CST 2024