Changing NLS_TERRITORY VALUE
451164Aug 24 2005 — edited Aug 24 2005Can someone please tell me how I can change the default NLS_TERRITORY value for a 9i database?
Lets say I want to change it to France with the alter system command, I get this.
alter system set nls_territory='UNITED KINGDOM' scope=spfile
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option
If I modify my pfile, and add the parameter
*.nls_territory='UNITED KINGDOM'
Create a new spfile, no errors. Start the database, no errors.
SQL> select * from nls_database_parameters where parameter='NLS_TERRITORY';
PARAMETER VALUE
------------------------------
NLS_TERRITORY AMERICA
Is it possible to change this setting?
Thanks,
Ryan