Development/Database
Oracle XE 10g alter default character set
zennken
2016. 11. 8. 13:49
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_CHARACTERSETKO16MSWIN949