oracle charset change

CHARSET check queries :
select parameter, value from nls_database_parameters where parameter = 'NLS_CHARACTERSET'

 

CHARSET Change

 

Connect account as SYSTEM 

update sys.props$ set value$='KO16MSWIN949' where name='NLS_CHARACTERSET'; 
update sys.props$ set value$='KO16MSWIN949' where  name='NLS_NCHAR_CHARACTERSET';
update sys.props$ set value$='KOREAN_KOREA.KO16MSWIN949' where name='NLS_LANGUAGE';
commit;
 
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;

 

 

>>>references,

http://bluescor.tistory.com/entry/%EC%98%A4%EB%9D%BC%ED%81%B4-CHARSET-%ED%99%95%EC%9D%B8-%EB%B3%80%EA%B2%BD