오라클 한글 설정

* oracle Character set을 변경하려면 sysdba로 접속해야 한다.

command>SQLPLUS "/AS SYSDBA"

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 KO16KSC5601;

SQL>SHUTDOWN IMMEDIATE;

SQL>STARTUP;