首先查询数据库编码：

select userenv('language') from dual;

得到：

【更改编码】

--修改Oracle数据库字符集为utf-8:SQL>conn / as sysdba;SQL>shutdown immediate;SQL>startup mount;SQL>alter system enable restricted session;SQL>alter system set job_queue_processes=0;SQL>alter system set aq_tm_processes=0;SQL>alter database open;SQL>alter database character set internal_use utf8; --zhs16gbkSQL>shutdown immediate;SQL>startup;

再次执行：

-- 下面直接复制：

--修改Oracle数据库字符集为utf-8:conn / 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;alter database open;alter database character set internal_use utf8; --zhs16gbkshutdown immediate;startup;