oracle字符集修改

Oracle XE 执行安装程序后，很简单的默认为 SIMPLIFIED CHINESE_CHINA.AL32UTF8 ，通过如下方法可以修改成为 ZHS16GBK

cmd进入到windows命令行，一步步执行以下语句

sqlplus / as sysdba;

select userenv('language') from dual;

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

shutdown immediate;

startup ;

select userenv('language') from dual;