http://stackoverflow.com/questions/9463092/how-to-change-oracle-10gr2-express-editions-default-character-set
/* Oracle XE 10g alter default character set */
connect sys/xxxxx as sysdba
shutdown immediate
startup mount
alter system enable restricted session ;
alter system set JOB_QUEUE_PROCESSES=0;
alter system set AQ_TM_PROCESSES=0;
alter database open;
alter database character set internal_use KO16MSWIN949;
shutdown immediate
startup
SQL>
select
*
from
nls_database_parameters
where
parameter =
'NLS_CHARACTERSET'
;
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
KO16MSWIN949