How to change NLS_TERRITORY

Oct 19, 2015 4:28PM

Tried to change the NLS_TERRITORY for a database, followed. (old value : AMERICA)

alter system set nls_territory='UNITED KINGDOM' scope=spfile;

restarted the instance.

But when I select again, still shows AMERICA value:

SQL> show parameter nls_ter

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

nls_territory string AMERICA

SQL> select value from NLS_DATABASE_PARAMETERS where parameter ='NLS_TERRITORY';

VALUE

--------------------------------------------------------------------------------

AMERICA

But I see change in Instance level. Does this make any difference???

SQL> select value from nls_instance_parameters where parameter='NLS_TERRITORY';

VALUE

-------------------------------------------------------------------------------

UNITED KINGDOM

Does this make it any difference in changing instance level, but no at DB level.??

Database Administration (MOSC)