Oracle Character set conversion: AL32UTF8->ZHS16GBK

Select Userenv (' language ') from dual;

--Modify the Oracle database character set to ZHS16GBK:

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 ZHS16GBK; --utf8



Sql>shutdown immediate;

sql>startup;

Oracle Character set conversion: AL32UTF8->ZHS16GBK