[ORACLE] 캐릭터셋변경(10쥐로 테스트)

SQLPLUS> sqlplus /nolog
SQLPLUS> conn /as sysdba

SQLPLUS> SHUTDOWN IMMEDIATE;
SQLPLUS> STARTUP MOUNT;
SQLPLUS> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQLPLUS> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQLPLUS> ALTER DATABASE OPEN;
SQLPLUS> ALTER DATABASE CHARACTER SET KO16KSC5601;
SQLPLUS> ALTER DATABASE NATIONAL CHARACTER SET KO16KSC5601;

SQLPLUS> update props$ set value$='KO16KSC5601' where name='NLS_CHARACTERSET';
SQLPLUS> commit;

SQLPLUS> update props$ set value$='KO16KSC5601' where name='NLS_NCHAR_CHARACTERSET';
SQLPLUS> commit;

SQLPLUS> shutdown immediate;

SQLPLUS> STARTUP

SQLPLUS> SELECT * FROM sys.props$


출처 - 정민선배ㅋ