Home » RDBMS Server » Server Administration » NLS_language, NLS_territory
NLS_language, NLS_territory [message #63246] Wed, 22 September 2004 05:38 Go to next message
Alex
Messages: 190
Registered: August 1999
Senior Member
Hi,

maybe it is a stupid question, but my problem is like following:

We have several 9.2.0.4-INstances on a redhat el 3.0, all with american nls_language and nls_territory.

Now I have to create a databse with german parameters. I tested a creation of a database in my testenviroment (OS w2000), where I changed the parameters (NLS_language germany, NLS_territory german) in the init.ora while using the configuration assistant.

When I make the query "select * from nls_session_parameters" now, I see the parameters like I set. But when I run the query "select * from props$ where name like 'NLS%'", the parameters are all on 'america'.

Can anybody tell me why?

Or tell me how I mange it to make a "german" database?

 
Re: NLS_language, NLS_territory [message #63255 is a reply to message #63246] Wed, 22 September 2004 12:38 Go to previous messageGo to next message
croK
Messages: 170
Registered: April 2002
Senior Member
Have you tried do some ALTER SESSION SET NLS_LANG=XXX ?

best luck.
www.consultoria-oracle.com
Remote DBA available for hire.
Re: NLS_language, NLS_territory [message #63262 is a reply to message #63255] Thu, 23 September 2004 00:09 Go to previous message
Alex
Messages: 190
Registered: August 1999
Senior Member
Thank you,
but I think I understand it now.
Previous Topic: understanding recovery from arc/redo logs
Next Topic: Export
Goto Forum:
  


Current Time: Thu Jan 09 14:09:33 CST 2025