打开SQL Plus,登录,逐行输入下面的命令:
--查看Oracle数据库当前的字符集:
select userenv('language') from dual;
-- SIMPLIFIED CHINESE_CHINA.ZHS16GBK
-- SIMPLIFIED CHINESE_CHINA.AL32UTF8
--修改Oracle数据库字符集为utf-8:
--oracle_home=d:\app\Administrator\product\11.2.0\dbhome_1
--oracle_sid=orcl
--sqlplus sys/sys@192.168.0.76/orcl as sysdba;
sqlplus 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;
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载