修改 oracle xe 預設中文字元集成為：SIMPLIFIED CHINESE_CHINA.ZHS16GBK____oracle

Oracle XE 執行安裝程式後，很簡單的預設為 SIMPLIFIED CHINESE_CHINA.AL32UTF8 ，通過如下方法可以修改成為 ZHS16GBK
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;