oracle编码转换：AL32UTF8->ZHS16GBK

 

--修改Oracle数据库字符集为utf-8:  
  
SQL>conn / as sysdba;  
  
SQL>shutdown immediate;  
  
SQL>startup mount;  
  
SQL>alter system enable restricted session;  
  
SQL>alter system set job_queue_processes=0;  
  
SQL>alter system set aq_tm_processes=0;  
  
SQL>alter database open;  
  
SQL>alter database character set internal_use utf8; --zhs16gbk  
  
   
  
SQL>shutdown immediate;  
  
SQL>startup;  

　　

直接复制

--修改Oracle数据库字符集为utf-8:  
  
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 internal_use utf8; --zhs16gbk  
  
   
  
shutdown immediate;  
  
startup;  

　　

转载于:https://www.cnblogs.com/guohu/p/7100243.html