| NLS_Character set [message #627463] |
Wed, 12 November 2014 03:10  |
prejib
Messages: 126
Registered: March 2009
Location: India
|
Senior Member |
|
|
Hi ,
I need to set the nls_language and nls_territory to American America. Currently it is 'MEXICAN SPANISH' so the ORA- error comments are coming in Spanish. How can I set this to AMERICAN AMERICA. When I go thru the oracle documents(Setting Up a Globalization Support Environment) , it gives the command for session and environments but not for the initialization parameters. Please help me to change NLS_LANGUAGE in the initialization parameter . Current values are given below .
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 AL32UTF8
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 TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 11.2.0.1.0
20 rows selected.
SQL> show parameter nls
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_calendar string
nls_comp string BINARY
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
nls_iso_currency string
[b]nls_language string MEXICAN SPANISH[/b]
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_sort string
[b]nls_territory string MEXICO[/b]
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string
SQL>
Thanks & Regards,
Prejib
|
|
|
|
| Re: NLS_Character set [message #627485 is a reply to message #627463] |
Wed, 12 November 2014 05:26  |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You change them as you change any other parameters: modifying init.ora or using ALTER SYSTEM.
However, note that any setting you made at instance level will be overridden by client ad session settings.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
