oracle utf16转utf8,oracle编码转换：AL32UTF8->ZHS16GBK

--修改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; --zhs16gbk

SQL>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; --zhs16gbk

shutdown immediate;

startup;

原文：http://www.cnblogs.com/guohu/p/7100243.html