Wednesday, 24 September 2014

change oracle database character set

change oracle database character set from WE8MSWIN1252 to AL32UTF8 and from AL32UTF8 to WE8ISO8859P1 :-

[oracle@netmindtwcint ~]$ sqlplus sys/sys as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Wed Sep 24 17:10:31 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT *
FROM V$NLS_PARAMETERS
WHERE PARAMETER = 'NLS_CHARACTERSET';  2    3

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CHARACTERSET
WE8MSWIN1252


SQL> UPDATE PROPS$
SET VALUE$ = 'AL32UTF8'
WHERE NAME = 'NLS_CHARACTERSET';  2    3

1 row updated.

SQL> COMMIT;

Commit complete.

SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area  535662592 bytes
Fixed Size                  1345376 bytes
Variable Size             327157920 bytes
Database Buffers          201326592 bytes
Redo Buffers                5832704 bytes
Database mounted.
Database opened.
SQL> SELECT *
  2  FROM V$NLS_PARAMETERS
  3  WHERE PARAMETER = 'NLS_CHARACTERSET';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8


SQL> we8iso8859p1
SP2-0734: unknown command beginning "we8iso8859..." - rest of line ignored.
SQL> UPDATE PROPS$
  2  SET VALUE$ = 'WE8ISO8859P1'
  3  WHERE NAME = 'NLS_CHARACTERSET';

1 row updated.

SQL> COMMIT;

Commit complete.

SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>  startup;
ORACLE instance started.

Total System Global Area  535662592 bytes
Fixed Size                  1345376 bytes
Variable Size             327157920 bytes
Database Buffers          201326592 bytes
Redo Buffers                5832704 bytes
Database mounted.
Database opened.
SQL>  SELECT *
  2  FROM V$NLS_PARAMETERS
  3  WHERE PARAMETER = 'NLS_CHARACTERSET';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CHARACTERSET
WE8ISO8859P1




No comments:

Post a Comment