오라클 캐릭터셋 변경

 

캐릭터셋 확인

  
  select parameter, value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
  

 

 

CHARSET 변경

  
  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;