您的位置:首页 > 博客中心 > 数据库 >

oracle 字符集转换:AL32UTF8->ZHS16GBK

时间:2022-03-14 02:34

select userenv(‘language‘) from dual; 

 

--修改Oracle数据库字符集为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;

热门排行

今日推荐

热门手游