Oracle数据库查看字符集并更改

select userenv('language') from dual;

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 AL32UTF8;

shutdown immediate;

startup

alter system set job_queue_processes=1000;

select userenv('language') from dual;