오라클 CHARSset 확인 및 변경

CHARSET 확인 쿼리문 : 

SQL > select parameter, value from nls_database_parameters where parameter = 'NLS_CHARACTERSET'

CHARSET 변경 방법 :

SYSTEM 계정으로 connect 한다.

 

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

SQL >update sys.props$ set value$='KO16MSWIN949' where  name='NLS_NCHAR_CHARACTERSET';

SQL >update sys.props$ set value$='KOREAN_KOREA.KO16MSWIN949' where name='NLS_LANGUAGE';

SQL >commit;

 

DB 재부팅을 해야 합니다.

SQL >SHUTDOWN IMMEDIATE;

SQL >STARTUP MOUNT;

SQL >ALTER SYSTEM ENABLE RESTRICTED SESSION;

SQL >ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

SQL >ALTER SYSTEM SET AQ_TM_PROCESSES=0;

SQL >ALTER DATABASE OPEN;

SQL >ALTER DATABASE CHARACTER SET INTERNAL_USE KO16MSWIN949;

SQL >SHUTDOWN IMMEDIATE;

SQL >STARTUP;

SQL > select parameter, value from nls_database_parameters where parameter = 'NLS_CHARACTERSET'