CODEWITHSUNDEEP
oracle-databasenls
user
user

Reputation: 167

changing NLS_TERRITORY and NLS_LANGUAGE permanently

When I execute "select * from SYS.NLS_INSTANCE_PARAMETERS" in SQL Developer, result includes GERMAN for NLS_LANGUAGE and GERMANY for NLS_TERRITORY. Now I need to change those values to AMERICAN respectively AMERICA permanently. How can this be done? There're so many documentations online, but I coulnd't find a simple guide. thanks for your help

Upvotes: 0

Views: 1601

Answers (1)

EdStevens
EdStevens

Reputation: 3872

Depending on if you are using a pfile or spfile. If using a pfile, edit the file and restart the database. If using an spfile (as you should be doing), then use the ALTER SYSTEM SET command, as documented here.

Why do you want to do this? What problem are you really trying to solve? Are you aware that even if you set this at the database level, clients can override it with ALTER SESSION?

Upvotes: 1

Related Questions