NLS_language, NLS_territory [message #63246] |
Wed, 22 September 2004 05:38 |
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?
|
|
|
|
|