배우기

ORACLE XE NLS_CHRACTERSET 변경

우썅 2013. 2. 21. 15:48

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;

select * from nls_database_parameters where parameter like '%CHAR%';


출처 : http://joke00.tistory.com/176