1.在SQL*PLUS 中,以DBA登录
conn / as sysdba
>shutdown immediate; (把database停了)
>startup mount; (把database重开去可更改情況)
>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 utf8;
或者
>alter database character set internal_use utf8;
或者
>alter database character set internal_use ZHS16GBK ;
>shutdown immediate;
>startup; (重开正常oracle)
>select userenv('language') from dual;
常见的Oracle字符集有ZHS16GBK、AL32UTF8、US7ASCII等。