代码改变世界

修改oracle服务器端字符集

2015-07-13 16:26  NO.27  阅读(476)  评论(0)  编辑  收藏  举报 
----设置字符集步聚-------
conn /as sysdba;
shutdown immediate;
startup mount;
alter system enable restricted session;
alter system set job_queue_processes=0;
alter database open; 
alter database character set internal_use ZHS16CGB231280;（默认值：ZHS16GBK）
shutdown immediate; 
startup;
-------end-----------------