Changing NLS session parameters permanently
Hi,
I have a 8i database with the following session and database NLS parameters....
SQL> SELECT * FROM nls_session_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE DUTCH
NLS_TERRITORY THE NETHERLANDS
NLS_CURRENCY f
NLS_ISO_CURRENCY THE NETHERLANDS
NLS_NUMERIC_CHARACTERS ,.
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MM-RR
NLS_DATE_LANGUAGE DUTCH
NLS_SORT DUTCH
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD-MM-RR HH24:MI:SSXFF
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MM-RR HH24:MI:SSXFF TZH:TZM
NLS_DUAL_CURRENCY ┐
NLS_COMP BINARY
SQL> SELECT * FROM nls_database_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8ISO8859P1
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_NCHAR_CHARACTERSET WE8ISO8859P1
NLS_RDBMS_VERSION 8.1.7.4.1
I want to change the nls_session_parameters to American/America (same as the nls_database_parameters) permanently so that all future sessions will use American/America values.
I thought that restarting the database would do the trick, but unfortunately it doesn't.
Using Alter System set.... is also not possible.
In the init.ora there are no nls parameters defined.
How can I change the nls session parameters permanently? Thanks.