Oracle charset 확인, 변경

charset 확인

SELECT name, value$
FROM sys.props$
WHERE name in('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');

NAME
------------------------------------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_LANGUAGE
AMERICAN

NLS_TERRITORY
AMERICA

NLS_CHARACTERSET
AL32UTF8


NAME
------------------------------------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_NCHAR_CHARACTERSET
AL16UTF16

 

charset 변경

update props$ set value$='{AMERICAN, KOREAN 등 변경하려는 문자셋}' where name='NLS_LANGUAGE';
update props$ set value$='{AMERICA, KOREA 등 변경하려는 문자셋}' where name='NLS_TERRITORY';
update props$ set value$='{AL32UTF8, KO16KSC5601 등 변경하려는 문자셋}' where name='NLS_CHARACTERSET';
commit;
shutdown immediate;
startup;

SYSTEM 관리자로 로그인해서 진행한다.