Changing NLS_CHARACTERSET
683467Feb 5 2009 — edited Feb 5 2009Hi,
I am trying to change NLS_CHARACTERSET , but somehow the command
ALTER SESSION SET NLS_CHARACTERSET=WE8ISO8859P1;
is not working.
Kindly Help.
Below are the screenshots of the commands executed by me,
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 5 17:07:16 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the OLAP and Data Mining options
SQL> select *
2 from v$version
3 /
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> select *
2 from v$nls_parameters
3 where parameter in ('NLS_CHARACTERSET','NLS_LANGUAGE')
4
SQL> /
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_LANGUAGE
AMERICAN
NLS_CHARACTERSET
WE8MSWIN1252
SQL> ALTER SESSION NLS_CHARACTERSET = WE8ISO8859P1
2 /
ALTER SESSION NLS_CHARACTERSET = WE8ISO8859P1
*
ERROR at line 1:
ORA-00922: missing or invalid option
SQL> select *
2 from v$nls_parameters
3 where parameter in ('NLS_CHARACTERSET','NLS_LANGUAGE')
4 /
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_LANGUAGE
AMERICAN
NLS_CHARACTERSET
WE8MSWIN1252
SQL>