Oracle 11g Character set 확인 및 변경

sqlplus "/as sysdba" 를 통해 접속

Character set 확인

select name, value$

from props$

where name in ('NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET');

Character set 수정

update sys.props$ set value$='KO16MSWIN949' where name = 'NLS_CHARACTERSET';

commit;