Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Changing NLS_TERRITORY VALUE

451164Aug 24 2005 — edited Aug 24 2005
Can 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2005
Added on Aug 24 2005
2 comments
2,694 views