오라클 characterset 변경하기

shotdown 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 AL32UTF8; (혹은 KO16MSWIN949 AL16UTF16)

 

SHUTDOWN IMMEDIATE; — or SHUTDOWN NORMAL;

STARTUP;

SQL > select * from nls_database_parameters ORDER BY PARAMETER;

update sys.props$ set value$='원하는NLS_CHARCTERSET' where name='NLS_CHARACTERSET';

update sys.props$ set value$='원하는NLS_NCHAR_CHARACTERSET' where name='NLS_NCHAR_CHARACTERSET';

KOREAN_KOREA.KO16MSWIN949

AL32UTF8

AL16UTF16