OracleXE版本登录并修改字符集

==登录Oracle（带服务名）

set oracle_sid=xe;
conn sys/taoistwar@xe as sysdba;

==修改Oracle 10g Express Edition的字符集
connect system as sysdba ; 
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 ;