oracle修改字符集

select userenv('language') from dual   #查看字符集

sqlplus /nolog   #打开链接
 conn /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 ZHS16GBK; 

 ALTER DATABASE character set INTERNAL_USE ZHS16GBK; 
 shutdown immediate; 

 startup 

select userenv('language') from dual