设置oracle的字符集

2017-01-01 10:46
sqlplus /nolog
conn / as sysdba
shutdown immediate; /关闭数据库服务器
startup mount;
alter session set sql_trace=true;
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;
alter session set sql_trace=false;
shutdown immediate;
startup;

查看编码格式:
select userenv('language') from dual;