'Oracle'에 해당되는 글 1건

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


Posted by zennken
1

zennken

달력