BreakingBad

오라클 NLS_LANGUAGE, NLS_TERRITORY, NLS_CHARACTERSET 변경

SQL> UPDATE sys.props$ SET VALUE$='KOREAN' WHERE NAME='NLS_LANGUAGE';

SQL> UPDATE sys.props$ SET VALUE$='KOREA' WHERE NAME='NLS_TERRITORY';

SQL> UPDATE sys.props$ SET VALUE$=KO16KSC5601' WHERE NAME='NLS_LANGUAGE';

SQL> COMMIT;

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP

** ORACLE DB IMPORT 시  sys.props 테이블의 character set  등 정보 확인할 것